Deselect option buttons

[Guest]

I have a series of option buttons linked to a single cell. Once an option is
selected and if I change my mind and don't want any option selected, how do I
deselect all so that no option is selected?

If I clear the linked cell, that works but the linked cell is supposed to be
hidden from users so I wouldn't want the user to clear the linked cell. The
only thing I can think of is putting a macro button as one of the selections
to clear the linked cell.

Is there some other way to do this? I'm using option buttons from the Forms
toolbar.

Thank you

 

[Guest]

hi,
a suggestion...
put a label control under(or over) your options buttons. give it a caption
of 'clear options' or just 'clear' or 'c'.
sub Labe1_click()
OptionButton1 = False
OptionButton2 = False
Otherbuttons = False
end sub

an idea.
regards
FSt1