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
|