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