2Writing Your Own Macros
IN THIS CHAPTER
Activating the Ribbon’s Developer Tab
Displaying the Visual Basic Editor
Touring the Visual Basic Editor
Creating a User-Defined Function
Taking Advantage of IntelliSense
Letting VBA do all the work by recording your macros is an easy way to automate tasks, and it’s a technique you’ll use often. However, to get the most out of VBA you need to do some full-fledged programming, which means writing your own macros, either from scratch or by using a recorded macro as a starting point.
Why go to all that trouble? Here are just a few of the advantages you gain by doing this:
• If you make a mistake while recording ...
Get Business Solutions VBA for the 2007 Microsoft Office System now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.