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 books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.