referencing a checkbox
I have been playing around with controls on excel 2007 and am getting
frustrated ofver something I am sure is very simple...I simply want to
perform an action when a checkbox = true. I have the following code:
Sub CheckBox1_Click()
If CheckBox1 = True Then
ThisWorkbook.Sheets("Sheet1").Cells(1, 1) = "A"
End If
End Sub
For some reason this code does not recognize when the checkbox is true or
not. can someone point me in the right direction?
Thanks!
Chad
|