2. Writing Your Own Macros
In This Chapter
• Understanding the advantages of writing your own macros
• Getting to know the Visual Basic Editor
• The basic steps required to write a macro
• Learning how to craft your very own user-defined functions
• Creating and using procedures
• Understanding and working with VBA modules
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. Here are just a few of the advantages you gain by doing this:
• If you make a mistake while recording a macro, ...
Get Absolute Beginner's Guide to VBA now with the O’Reilly learning platform.
O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.