JIYIK CN >

We will look at different ways to exit a sub in VBA through examples.

Using the Exit Sub Statement in VBA

While using Sub in VBA, we may want to exit it or prevent it from executing further if an error occurs or the user provides wrong input. We can also terminate the sub at any time using exit sub.

In VBA, each line is executed line by line, so if we have reached the result or the expected response at a certain point of execution is not what we want, we can terminate the sub using exit sub.

There are many situations where we can use this feature. Let's go through an example and try to exit the sub in the middle of the code.

Sample code:

# VBA
Sub roundFunc()
Dim num As Double
num = 5.468
Exit Sub
MsgBox Application.WorksheetFunction.RoundUp(num, 1)
End Sub

From the above example, I have added the exit sub code before the message box and when we run this code, no message box appears.

Let's take another if-elseexample using the if statement. If the statement is true, it will execute the code until the end. Otherwise, it will break.

Sample code:

# VBA
Sub roundFunc()
Dim num As Double
num = 5.468
If Application.WorksheetFunction.RoundUp(num, 1) = 6 Then
    MsgBox num
Else
    MsgBox "Wrong Number"
    Exit Sub
num = num + num
End If
End Sub

Output:

When we are dealing with important data, we want to make sure that if there is any mistake or any input error, we need to exit the sub immediately to ensure that no data is lost or there is no wrong data inside the company data.