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

Chapter 46. Introducing Visual Basic for... > Recording and Modifying VBA Modules

Recording and Modifying VBA Modules

As an introduction to Visual Basic for Applications modules, you are going to let Excel write the first module. Excel's Macro Recorder records all your interactions with a worksheet as a sequence of Visual Basic commands. These commands form a macro procedure that you can execute to replay your interactions. This capability is especially useful for formatting complex worksheets, because after you have recorded the formatting, you only have to replay the procedure to format another sheet.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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