Thread: How to Start a Macro by physically checking a check box?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
  
Posts: 3,942
Default How to Start a Macro by physically checking a check box?
hi
try this......
Private Sub CheckBox1_Click()
If Me.CheckBox1.Value = True Then
Call myfirstmacro
End If
End Sub

change any names if needed.
regards
FSt1

"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?

Reply With QuoteReply With Quote