Skip to content

VBA End

Associated Files Download Links

In VBA, to end ALL code execution use the End command.

When the execution of the code comes to End, it will immediately finish the execution and leave the program.

If you want to learn how to exit a Sub on Error, click on this link: VBA On Error Exit Sub

If you want to learn how to exit a Sub or Function, click on this link: VBA Exit Sub or Function

 

Exit all Code in VBA

You will see on the example what happens when we use the End command in VBA. We created a Sub EndSub, which has the End command inside. This Sub is called from CallEndSub. Here is the code:

 

In the EndSub, we first enter the For Loop if the value of i is less than 10:

After that we check if the value of i is equal to 5, using the If command. If the value is 5, we return the message box with the value of i and use the command End.

If the condition is not met, the following statement increases i by 1 and enters in the For loop again:

 

In the CallEndSub, we first call the Sub EndSub:

After that we return the Message box:

 

If you run the CallEndSub, it will first call the EndSub. If you execute this code in the debug mode, you will see that it will go through the loop 5 times. In the 5th iteration, the value of the variable i becomes 5 and the code enters in the If body. Now the MsgBox “The value of i is ” & i is executed and End after that:

vba end

Image 1. VBA End

 

As you can see, the code execution is stopped right after the End command, so the MsgBox “End Sub” is never executed.

You may also like some of this related content...

In VBA, you can exit a Sub or Function, by using the Exit Sub or
Advertisements
Automate Excel
Left Menu Icon