So now we understand the background, let’s go ahead and create a macro. Any VBA application you create is a essentially collection of Subs. By Macro we mean a Sub.Ī Sub(short for Subroutine) is simply a collection of lines of VBA code that perform certain tasks. In the following sections, we are going to create a Macro from scratch. VBA is also packaged with all other Microsoft Office application such as Microsoft Word, Access and Outlook. It is very powerful and allows you to extend the functionality of Excel. VBA is the programming language, Visual Basic for Applications. This language comes pre-installed with Excel. Generally speaking, somebody new to VBA will use the term Macros and once they become familiar they use the term VBA. When the terms Excel Macros or VBA are used they are referring to the same thing.

In a nutshell, Excel Macros refers to the programming language VBA that comes built-in to Excel.

The term “Excel Macros” causes a lot of confusion. 3 Step 1 Make the Developer Tab Visible.

Basic excel macros