Private Sub CheckBox1_Change()
If CheckBox1.Value = True Then
Range("a4").Value = 12
End If
End Sub

If this post helps click Yes
---------------
Jacob Skaria


"Ezequiel" wrote:

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