View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default 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.