Run a Macro from Another Macro in Excel

Add to Favorites
Author:

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