Chapter 1. Recording Your First Macro

     

In this chapter

  • Understanding what macros are all about

  • Appreciating the advantages of macros

  • Learning about VBA procedures

  • Recording your first macro

  • Viewing and editing your recorded macro

This chapter gets your VBA education off to a rousing start by introducing you to some macro basics. You'll begin, appropriately enough, at the beginning by learning just what macros are, what you can do with them, and why you should learn any of this stuff. You'll then get a brief introduction to VBA procedures, but that will be the end of the theoretical portion of the show. You'll also get down to brass tacks by learning to compose macros the easy way: by recording them automatically. From there, you'll learn how to view the resulting macro and how to edit it using the Visual Basic Editor. This will set the stage for the next few chapters where you take a closer look at the specifics of the VBA language.



Absolute Beginner's Guide to VBA
Absolute Beginners Guide to VBA
ISBN: 0789730766
EAN: 2147483647
Year: 2003
Pages: 146

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net