If, ElseIf, Else Statements with Multiple Conditions

[torminator111]

Hi All!

I have been experiencing this issue in a few macros I've created and don't understand what is wrong with any of the syntax structures I've been experimenting with. When I run the code, it doesn't compile and gives me a message that says "Else without If." From online research, it seems that the syntax is correct. Any ideas?

Structure 1 (If, ElseIf, Else:
If vara = "NA" Or varb = "W" GoTo Proceed
ElseIf varx = "" Or vary = "" Or varz = "" _
Then MsgBox "Main Information missing, please check Main entries", vbExclamation: GoTo Suspend
Else: GoTo Suspend
End If

Structure 2 (nested Ifs):

If varx = "" Or vary = "" Or varz = "" Then
If vara = "NA" Or varb = "W" GoTo Proceed
Else: MsgBox "Main Information missing, please check Main entries", vbExclamation: GoTo Suspend
End If
Else: GoTo Proceed
End If

Structure 3 (complex If conditions):
If (vara = "NA" Or varb="W") And (varx="" Or vary="" Or varz="") GoTo Proceed
Else: MsgBox "Main Information missing, please check Main entries", vbExclamation: GoTo Suspend
End If


Thank you SO MUCH in advance for your help!

 

[CodeNinja]

You are using elseif as if it were self closing. It isnt. Think of it this way...

If vara = "NA" Or varb = "W" 
        GoTo Proceed
Else
        If varx = "" Or vary = "" Or varz = "" Then 
              MsgBox "Main Information missing, please check Main entries", vbExclamation
              GoTo Suspend
        Else
             GoTo Suspend
        End if
End If

 

[torminator111]

Hmm. That makes sense. I am, however, still unable to compile the code (with the error message "Else without If"). Could this be something with my computer?