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