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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"opieandy" wrote:

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 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


"Shane Devenshire" wrote:

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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"opieandy" wrote:

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