View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Oreg[_39_] Oreg[_39_] is offline
external usenet poster
 
Posts: 1
Default What is wrong with this code?


Hi sungen99,

try this:

Sheets("Sheet1").Select
If Range("H20").Text = "FALSE" Then
MsgBox "NOT CHECKED"
Else
MsgBox "CHECKED"
End If

End Sub

Ore

--
Ore
-----------------------------------------------------------------------
Oreg's Profile: http://www.excelforum.com/member.php...nfo&userid=919
View this thread: http://www.excelforum.com/showthread.php?threadid=47551