May 1999
Intermediate to advanced
1440 pages
38h 6m
English
The macro recording examples you've seen so far have been pretty simple, and the macro recorder has done a reasonably good job of capturing the actions recorded. When you record a macro that uses a built-in dialog box, however, you might find that you're in for a surprise. As you'll see in the example that follows, you might get a lot more VBA code than you're interested in.
Of course, using dialog boxes while you record is very convenient. By choosing one command, you can choose many preferences or options at a time. Also, in some cases there aren't any toolbar buttons or keyboard shortcuts for the features you want to record.
Suppose you need a macro to emphasize selected text by changing the font ...
Read now
Unlock full access