Hi All,

I have several checkboxes in a userform

I want to run the same code if any one or several of them is selected
or run another code if anyone of them or several of them deselected.

How can i do this..

Thanks for all the help

Do you mean this ?

Private Sub CheckBox1_Click()
If Me.CheckBox1.Value = True Then
'macro 1
Else
macro2
End If
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Soniya" wrote in message oups.com...
Hi All,

I have several checkboxes in a userform

I want to run the same code if any one or several of them is selected
or run another code if anyone of them or several of them deselected.

How can i do this..

Thanks for all the help

in that case i have to write code for each checkbox click or change
event. in my case any check box in the form i have to call the same
macro

If you have many then see
http://www.j-walk.com/ss/excel/tips/tip44.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Soniya" wrote in message oups.com...
in that case i have to write code for each checkbox click or change
event. in my case any check box in the form i have to call the same
macro