Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Double click to clear option button
Does anyone know a way to clear an option button (radio button) by just
double clicking on it? I'm talking about the little circle that once clicked can't be unchecked unless you right click and click clear contents. My real goal was to create VBA code that would simply reset the option button if just clicked again (kind of like a regular check box)--but I couldn't figure it out. Double-clicking would work fine too. Can't use right-click because all command bars are disabled. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Double click to clear option button
I hope you are having this within the sheet. The best way is to link the
button with a cell in DesignModeProperties..and change the cell value to 0,1 If this post helps click Yes --------------- Jacob Skaria "dgold82" wrote: Does anyone know a way to clear an option button (radio button) by just double clicking on it? I'm talking about the little circle that once clicked can't be unchecked unless you right click and click clear contents. My real goal was to create VBA code that would simply reset the option button if just clicked again (kind of like a regular check box)--but I couldn't figure it out. Double-clicking would work fine too. Can't use right-click because all command bars are disabled. Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Double click to clear option button
. . . or use a check box control?
"dgold82" wrote in message ... Does anyone know a way to clear an option button (radio button) by just double clicking on it? I'm talking about the little circle that once clicked can't be unchecked unless you right click and click clear contents. My real goal was to create VBA code that would simply reset the option button if just clicked again (kind of like a regular check box)--but I couldn't figure it out. Double-clicking would work fine too. Can't use right-click because all command bars are disabled. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Click to Clear Radio Button | Excel Programming | |||
In the Project window where will be the double click option | Excel Worksheet Functions | |||
Clear Option Button Selections | Excel Discussion (Misc queries) | |||
double-click mouse button not working | Excel Discussion (Misc queries) | |||
double click option in listbox outputs to cell in excel 97 ! | Excel Programming |