View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ezequiel Ezequiel is offline
external usenet poster
 
Posts: 2
Default Execute a macro automatically when checkbox is clicked

Hi!

I have a macro that I need to be executed automatically when a checkbox
called checkbox1 is clicked.

I tried with a simple macro like

Private Sub CheckBox1_Click()
If CheckBoxes("CheckBox1").Value = 1 Then
Range("a4").Value = 12
End If
End Sub

that is located at the corresponding sheet. The macro works fine when I
executed step by step, but is not running automatically when I click on
CheckBox1

Any idea?

Thanks,

Ezequiel