Excel 2007 Activex Option Button Default?
Solved/Closed
Related:
- Excel activex option button
- Excel vba add command button programmatically - How-To - Excel
- Spellnumber in rupees in excel 2007 ✓ - Forum - Office Software
- Spell number in excel 2007 indian rupees software download - Forum - Office Software
- How to take screenshot in excel 2007 - Guide
- Excel 2007 drop down list not working ✓ - Forum - Excel
2 replies
rizvisa1
Apr 19, 2012 at 04:21 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Apr 19, 2012 at 04:21 PM
Are you create the controls on run time or they are already created. You can set its value to "true". Default is false.
Ok, after playing around with the code a bit, I figured it out. I needed to use NwSheet.OptionButton1.Value = True, instead of OptionButton1.Value = True. I couldn't explain why, but it does the trick. I am guessing it has something to do with it trying to change the option button status on all the buttons. Now, I am trying to figure out how to lock the previous option buttons so they can't be changed after the command button is clicked.
Sometimes I just need to talk through the process with someone/somewhere to figure it out. I appreciate the outlet for my mental excercises.
Thank you,
Josh
Sometimes I just need to talk through the process with someone/somewhere to figure it out. I appreciate the outlet for my mental excercises.
Thank you,
Josh