How Does a Macro Work?

Welcome to my Macro Tutorials.  In this tutorial I will teach how a macro works. For a list of all my macro tutorials feel free to check out my Macro Tutorials.

Macros use a programming language called VBA.  VBA stands for Visual Basic for Applications.  VBA is an extension of the Visual Basic programming language designed to be used with applications such as Microsoft Office products.

When a macro is created a VBA Procedure is created.  A VBA Procedure is like a set of instructions for the macro.  Without the VBA Procedure or if the VBA Procedure name does not match the name of the macro, then the macro will not work properly.

These VBA Procedures are stored in a VBA Module within that workbook.  If no module already exists within the workbook then a VBA module is created. If this module is deleted then the Macros will be deleted too.