| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding OR conditions to IF-Then statement
Not getting the syntax right on this.....
Trying to capture results of either 0 or if the textbox is left blank.There is an Else statement after all this, but that part is ok. If TextBox6 < 1 Or "" Then This line highlights when the macro is run. I tried putting () in the statement, but obviously still don't have it right. Thanks, J.O. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adding OR conditions to IF-Then statement
If textbox6.value=0 or textbox6.value="" then
Alternatively: IF application.or(textbox6.value=0,textbox6.value="") then "excelnut1954" wrote: Not getting the syntax right on this..... Trying to capture results of either 0 or if the textbox is left blank.There is an Else statement after all this, but that part is ok. If TextBox6 < 1 Or "" Then This line highlights when the macro is run. I tried putting () in the statement, but obviously still don't have it right. Thanks, J.O. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adding OR conditions to IF-Then statement
Thanks Toppers!
So simple, yet so elusive. J.O. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If Statement On Two Conditions | Excel Worksheet Functions | |||
| Conditions with IF statement | Excel Discussion (Misc queries) | |||
| why can i use 3 conditions in SQL statement only? | Excel Programming | |||
| If then statement with two true conditions | Excel Programming | |||
| 3 conditions if else statement. | Excel Programming | |||
Hybrid Mode
