Related:
- Excel 2007 Activex Option Button Default?
- Spell number in excel 2007 indian rupees download ✓ - Forum - Office Software
- Date format not changing in excel 2007 ✓ - Forum - Excel
- Excel vba add command button programmatically - How-To - Excel
- Spell number in India Rupee - Forum - Office Software
- How to take screenshot in ms excel 2007 - How-To - Excel
2 replies
rizvisa1
- Posts
- 4476
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- August 2, 2020
Are you create the controls on run time or they are already created. You can set its value to "true". Default is false.
Josh
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
Subscribe To Our Newsletter!
