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

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

"Lookin for a job" wrote:

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