Run a Macro from Another Macro in Excel

Add to Favorites

I will show you how to run a macro from another macro in Excel.  This means that you can run any macro when you need to from a completely separate macro.

This is actually very simple!

Use Call in VBA.

Here is the macro we want to call or run using another macro:

Sub Macro_2()


MsgBox "Hi!"


End Sub

And here is the macro that will call or run this macro:

Sub Macro_1()


'call the second macro

Call Macro_2


End Sub

It is as simple as that.  Put Call in front of the name of the macro that you want to run.

Here is a screenshot of these two macros in Excel:

Download the spreadsheet for this tutorial, from below or the side-bar of this page, and you can test out these macros.


Question? Ask it in our Excel Forum

Downloadable Files: Excel File