O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required