Editing a Macro by Tweaking It in VBA

What if your macro contains a mistake, or you just want to change it? What if, for example, you really wanted the Gidget's Widgets logo to exhibit 10-point text instead of its current 14-point size?

The simplest way to modify the macro would be record it over again and delete the original. That might work if your macros are likely to be brief, but that scenario is still a bit bothersome—and once a macro gets a bit lengthier, the prospect of a do-over is less appealing still, in part because in the process of rerecording the macro you might very well make another mistake.

Is there an alternative? Yes—you can edit the macro in VBA.

Now, as mentioned, I'm not going to teach you the VBA language here; rather, we're just going to take a look at it and explore some easy ways to tweak it in order to edit a macro.