• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 31. Recording Macros > Behind the Scenes: The VBA Environment

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint