VBA: Break Out of Deeply Nested If Statements

vba if-statement break control-flow nested-if
user1205577 picture user1205577 · Nov 7, 2013 · Viewed 19.7k times · Source

Typically when I want to break out of a statement I just set a boolean flag for control flow, but I have a special case with many nested If statements and I'd really like to have a way to break out of several with one simple statement.

In Java you can name a loop and then break to that location; is there anything like that for VBA that can be used from a deeply nested location in If statements? I know VBA has the Exit statement for loops (while, for, etc), so I'm wondering if there is something similar for Ifs.

Ideally I'd like to do something this:

If ...
    *NAMED_IF*
    If ...
         If ...
          :
            *break out of NAMED_IF*
          :
        End If
    End If
    *Now We end up at this control position*
End If

Answer

Netloh picture Netloh · Nov 7, 2013

There isn't an if-statement specific method to break out of nested if-statements, but you could use the GoTo-statement instead:

If ...
    '*NAMED_IF*
    If ...
         If ...

            '*break out of NAMED_IF*'
            GoTo GoToHere

        End If
    End If
End If

'*Now We end up at this control position*
GoToHere:

Related questions

VBA: Conditional - Is Nothing

There is an If condition in a VBA application as seen below: If Not My_Object Is Nothing Then My_Object.Compute When the code is run in debug mode, I found that the If condition returns a true even …

Read More
If Statement With Multiple Lines

I have an if statement with multiple conditions. I cannot see them all in a single window view. Is there a way to separate them on different lines or do they have to be written all in one line?

Read More
Excel VBA - Skip sub or end sub IF Statement

My code loops through cell values in a table and sees if document with same name exists. If it does exist, it will perform an action to open those files and import data. If bProcess Then FileCounter = 0 For Each folderIDX …

Read More