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.
|