I am not certain if this will help with your problem.

But I created a blank **** and a checkbox and put the following code in
it:

Sub test()
If CheckBox1.Value = "True" Then
MsgBox ("True")
Else
If CheckBox1.Value = "False" Then
MsgBox ("False")
End If
End If
End Sub

It also works if you are referencing a cell's value.


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=551920