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.