Click Option Button 2x in a Row

  • Thread starter Thread starter opieandy
  • Start date Start date
O

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
 
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.
 
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
 
Back
Top