Checkbox in user form

[stonysleep]

I have a checkbox in a userform
Is it possible to run a sub on checking the checkbox and a different sub on unchecking?
I have only seen the syntax for running on click eg:

Private Sub CheckBox1_Click()

If not i will have to use buttons instead, but thought a checkbox would be more elegant

Thanks

 

[Trevor G]

You could create the sub routines outside the checkbox and then use the checkbox on change event to call the first procedure if checkbox.value=True and call the second procedure if checkbox.value=False

 

[andrewkard]

Hello,

If OptionButton1 = True Then MsgBox ("Ok")

 

[stonysleep]

Hello,

If OptionButton1 = True Then MsgBox ("Ok")

If statement worked perfectly
I think TrevorG was saying the same thing
Thanks

 

[andrewkard]

If statement worked perfectly
I think TrevorG was saying the same thing
Thanks

It is true. TrevorG was faster.

 

[Trevor G]

Thanks for letting me know.