How to trigger a macro on the basis of check box tick.

[ThrottleWorks]

Sir, I want to trigger a macro on the basis of check box tick.

I have inserted a check box in the file (Developer, Insert, Form Control).


My question is if the user ticks on check box (which is a true value) the macro should be triggered.


Is it possible, can anyone help me in this please.

 

[Luke M]

You'll need to use an ActiveX control instead of form (Developer, Insert, ActiveX control.

Once you;ve placed the macro, (and you're still in design mode) you can double click on the control and it should take you to the VBE with something a shell macro like this:

Private Sub CheckBox1_Click()
 
End Sub
Simply place a run command within here, or write the code that you need.
 
Example:
 
Private Sub CheckBox1_Click()
MyMacro
End Sub
 
Sub MyMacro()
'do cool stuff
End Sub

 

[ThrottleWorks]

You are awesome ! thanks a lot sir.

 

[Luke M]

No worries, you're welcome.