Double click to clear option button

D

dgold82

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

Jacob Skaria

I hope you are having this within the sheet. The best way is to link the
button with a cell in DesignMode>Properties..and change the cell value to 0,1

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Click to Clear Radio Button 10
Click to Reset Radio Button 4
Click to Reset Radio Button 1
Option buttons not responding 6
How to Set Focus a row - Option Button Click 2
Mouse double-click to select listbox item and run userform 3
Disable Clear DContents command in excel - vba code?? 3
Custom Right Click--VBA? 4

Top