How to Edit a Macro

Welcome to my Macro Tutorials.  For a list of all my Macro Tutorials feel free to check out my Macro Tutorials.

In the previous tutorial we created a new macro named GoodJob. In this tutorial I will teach you how to edit that GoodJob macro. If you have not been following along you just need to make a new macro named GoodJob.  If you don't know how to make a new macro feel free to read How to Create a Macro.


Lets Get Started.


Step 1: Open the Macro window.

Macro Window

Step 2: Select GoodJob from the list of macros Names.
Step 3: Select Edit to open the Visual Basic for Applications window.

Visual Basic for Applications Window

Step 4: Enter MsgBox "Good Job" inside GoodJob VBA Procedure outlined in red below.

Congratulations.  You edited a macro.  For the purpose of this tutorial you don't need to know what MsgBox "Good Job" means. Instead all you need to understand is that everything you want to have the macro run needs be between the Sub and End Sub lines.


In the next tutorial I will teach you How to Run a Macro.