View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy Patrick Molloy is offline
external usenet poster
 
Posts: 1,049
Default 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.