View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
papou[_9_] papou[_9_] is offline
external usenet poster
 
Posts: 52
Default How to detect optionbutton being clicked?

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?