View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
crapit crapit is offline
external usenet poster
 
Posts: 75
Default How to detect optionbutton being clicked?

I dont get what you mean! I know that there is some kind of click event,
but i dont know how to use!
"Bob Phillips" wrote in message
...
Because the macro will be entered if it is.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"crapit" wrote in message
...
I mean how to detect the optionbutton being clicked on it!
"papou" wrote in message
...
Hi crapit
Right click on your option button and choose Assign macro (please note

this
option may differ from yours - I am using a French version of Excel)
The macro thus assigned will fire each time your option button is

clicked

HTH
Cordially
Pascal

"crapit" a écrit dans le message de
...
The option button i'm refering to is not on the userform or control

box
but
from the "forms" menu. Do I need to initialize anything?