How to detect optionbutton being clicked?

[crapit]

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?

 

[papou]

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]

I mean how to detect the optionbutton being clicked on it!

 

[Bob Phillips]

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]

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]

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]

how do i set the optionbutton to be uncheck?

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]

how do i set the optionbutton to be uncheck using vba?

 

[Bob Phillips]

activesheet.optionbuttons("Option Button 1").value = xloff

--

HTH

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

 

[crapit]

Thanks for your eventhough I got it before ur reply! Btw, is it possible to
hide/unhide the control on the active sheet ?

 

[Bob Phillips]

Of course

activesheet.optionbuttons("Option Button 1").Visible = False

--

HTH

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

 

[crapit]

So for dropdown form control is it
activesheet.dropdown("drop down 1").Visible = False

If there are 3 columns of merge cell i.e A1 (A1 & A2), B1 (B1 & B2), C1
( C1 & C2 )
can i refer it as range("a1:c1")

 

[crapit]

I 'm unable to get this to work correctly,
ActiveSheet.DropDowns("dropdown143").Visible = True
It give unable to get the dropdown property of the class

What's wrong with it?

 

[Bob Phillips]

It works for me. Is it a Forms dropdown?

--

HTH

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