Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What is wrong with this code?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is wrong with the code? | Excel Discussion (Misc queries) | |||
What's wrong with this code??? | Excel Programming | |||
HELP! What's wrong with my code? | Excel Programming | |||
What is wrong with this code? | Excel Programming | |||
What's wrong w/my code? | Excel Programming |