Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Deselect option buttons
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Option Buttons | Excel Discussion (Misc queries) | |||
Option Buttons - groups | Excel Discussion (Misc queries) | |||
Option Buttons in Group Box | Excel Discussion (Misc queries) | |||
grouping of option buttons | Excel Discussion (Misc queries) | |||
Can I use more than one set of option buttons in a worksheet? | Excel Worksheet Functions |