Click Option Button 2x in a Row

[opieandy]

I would like to be able to click an option button twice. Presently, the
button remains "checked" after I click it. I cannot click it again. I don't
see anything in 'properties' to help with this. Any ideas?

Thanks,

Chris

 

[Shane Devenshire]

Hi,

What kind of button are you using - a command button, an option button?
Where is it, in the spreadsheet or on a user form.

Option buttons are usually put in the spreadsheet in groups of 2 or more.
If you only want to turn something on and off you generally use a checkbox,
less often a command button.

 

[opieandy]

Hi Shane,

It's an option button. There are 20 option buttons. Depending on which
button the user clicks, the option button pulls in data from another of 20
sheets.

I click the button for Sheet X to bring in that data, then I alter it, then
I want to reset it to its original form. I can't click the button for Sheet
X again. I can click the button for another sheet and then click the button
for Sheet X, but that's not a desirable solution.

Thanks,

Chris