How to Start a Macro by physically checking a check box?
If you'e written your macro you can right click your checkbox and assign the
code to it (Forms checkbox) then add this as the first line of your sub
Sub YourSub()
If ActiveSheet.CheckBoxes("Check Box 1").Value = xlOff Then Exit Sub
'Your code
End Sub
Mike
"Mr Imnotabrainsurgeon" wrote:
I have created my first macro (don't laugh) and I want the macro to start
when I check off a check box in the form I made.
How do I do this?
|