Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional "If Not ... Then" Statement not working properly Help!
The following code should pop up a message box but it is not doing so where
am I going wrong ? Sub test() Dim one As Boolean, two As Boolean, three As Boolean one = True two = True three = False If Not one = True And Not two = True And Not three = False Then MsgBox "One or more of the 3 conditions are false" End If End Sub Dan Thompson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Adjust row height" not working properly | Excel Discussion (Misc queries) | |||
Array function not working correctly if I use an "or - statement" | Excel Programming | |||
Unexpected Result with "If" Logic/Conditional Statement | Excel Discussion (Misc queries) | |||
Unexpected Result with "If" Logic/Conditional Statement | Excel Discussion (Misc queries) | |||
Can I include a "validation drop down" in a conditional statement? | Excel Worksheet Functions |