Microsoft® Office Excel 2003 Inside Out

Behind the Scenes: The VBA Environment

Now that you've recorded your macro, let's find out what Excel did. When you clicked OK in the Record Macro dialog box, Excel created something called a module in the active workbook. As you entered the company name and address in the worksheet, Excel recorded your actions and inserted the corresponding VBA code in the module.

The new module doesn't appear with the other sheets in the workbook; to view the module, choose Tools, Macro, Macros. Next, select the CompanyAddress macro, and click the Edit button. The Visual Basic Editor (VBE) starts up, and the module that contains the CompanyAddress macro appears, as shown in Figure 31-4.

Figure 31-4. Excel stores the VBA code for each action you performed in the ...