Sub Macro1()
Sheets("Sheet1").Select
If Range("H20").Select = "FALSE" Then
MsgBox "NOT CHECKED"
Else
MsgBox "CHECKED"
End If
End Sub
H20 contains the result of a checkbox of either a False or True. Seem
im always getting the Checked response which means im obviously no
getting the result form the sheet correctly.
Thanks again,
Ke
--
sungen9
-----------------------------------------------------------------------
sungen99's Profile:
http://www.excelforum.com/member.php...nfo&userid=914
View this thread:
http://www.excelforum.com/showthread.php?threadid=47551