Search results for query: *

Success, sort of. I always avoids spaces in names, I use Camel Case, but I could find no way of editing the name of the OBs, only their label. The code works if I use an activeX control instead of a form control. I was sure I'd tried this but I was tired by then and must have gotten something...

Yes, well, 'Option Button 1'.

Yes, it is sheet1. When I try that, it gives: Compile error: Method or data member not found It highlights '.OptionButton1' in blue, when I click ok, it highlights 'Sub Button2_Click()' in yellow.

Sorry, I should have said. If OptionButton1.Value = True Then That is the line that is apparently in error.

Hey. Thanks for your reply. Yes, I could do something like that, I have considered something similar, but I don't think it can work because I need the user to be able to fill in the options, the result to be saved and then the options reset. If I used your suggestion then surely as soon as the...

Hello. Not entirely sure this is the right forum to post this in, apologies if it isn't. I'm in a situation in Excel whereby I wish to have questions with option buttons. Upon clicking a 'save' button, a VB script is executed which checks which option buttons are selected and adds a 1 to the...