VBA: Where do I put the code?

• Recording a Macro in Excel

If you have completed my previous module you have recorded several macros with the macro recorder. You are likely now eagerly awaiting the opportunity to view your first code.

The VBA environment is pretty much the same in Excel 2003 and Excel 2010. In the video below I show give you a short tour of VBA in Excel 2010, don't worry if you have 2003 you will be able to follow along easily.

A Project is the composition of all VBA elements contained in a workbook.

A Module is a place holder within a workbook for your code.

You will notice when you recorded the macro excel created a new module for the code called "Module 1".

When first viewing your code. You will notice three things:

• Macros begin with code Sub (this stands for subroutine).
• Sub is followed by the name of the macro.
• Macros end with the statement End Sub.

In your recorded macros you will notice green text in the code window. These are comments. You can create a comment line by starting it with an apostrophe.

An apostrophe tells VBA the line doesn't contain code and is only informational.

As you begin to create more complicated macros, comments will become a necessity for remembering the purpose of each part of your code.

In the next module, we will learn to select to select and enter text in cells within Excel and from VBA. Click here when you are ready to proceed.