View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Per Jessen[_2_] Per Jessen[_2_] is offline
external usenet poster
 
Posts: 703
Default referencing a checkbox

On 11 Jul., 00:11, Chad wrote:
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


Hi

If CheckBox1.Value = True Then

Regards,
Per