Using a checkbox to activate/deactivate

[jeet_magic]

I have been trying to use a checkbox to activate or deactivate a process, it has however not worked for me...I've recently started using macros and would really appreciate help...thanks in advance!

This is what I wrote:

Sub CheckBox94_Click()
If CheckBox94.value = True Then
'run enable macro

Else
'run disable macro

End If
End Sub

Regards,
Jeet

 

[Andrew Poulsom]

Just put:

Call YourMacro

replacing YourMacro with the name of the procedure that you want to run.

 

[jeet_magic]

Thanks Andrew,
I used this instead:

Sub Macro1()
If Range("d11") = True Then
CheckPayroll
Else
UncheckPayroll
End If
End Sub

Works fine!