View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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?