View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
chad chad is offline
external usenet poster
 
Posts: 273
Default 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