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?

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?

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?

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?

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?

When you create a control from the forms menu, you get an option to assign a
macro (you can also get the same option by selecting it and right-clicking).

Assign a macro, and clicking the control fires the macro. Hence the macro
knows there has been a click.

--

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 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?