Posted to microsoft.public.excel.programming

Oreg[_39_] Oreg[_39_] is offline

external usenet poster

Posts: 1

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
What is wrong with this code?	jlclyde	Excel Discussion (Misc queries)	5	January 9th 08 05:12 PM
HELP! What's wrong with my code?	Sethaholic[_5_]	Excel Programming	0	July 11th 05 07:43 PM
HELP! What's wrong with my code?	Sethaholic[_6_]	Excel Programming	0	July 11th 05 07:37 PM
Can someone tell me what's wrong with this code please?	malycom	Excel Programming	4	June 3rd 04 03:26 PM
What is wrong with this code?	Matt	Excel Programming	0	January 22nd 04 08:11 PM

All times are GMT +1. The time now is 02:08 PM.

About Us

"It's about Microsoft Excel"