Datasheet

For example, you might create a VBA program to format and print your
month-end sales report. After developing and testing the program, you can
execute the macro with a single command, causing Excel to automatically
perform many time-consuming procedures. Rather than struggle through
a tedious sequence of commands, you can grab a cup of joe and let your
computer do the work — which is how it’s supposed to be, right?
In the following sections, I briefly describe some common uses for VBA
macros. One or two of these may push your button.
Inserting a bunch of text
If you often need to enter your company name, address, and phone number
in your worksheets, you can create a macro to do the typing for you. You can
extend this concept as far as you like. For example, you might develop a
macro that automatically types a list of all salespeople who work for your
company.
Automating a task you perform frequently
Assume you’re a sales manager and you need to prepare a month-end
sales report to keep your boss happy. If the task is straightforward, you can
develop a VBA program to do it for you. Your boss will be impressed by the
consistently high quality of your reports, and you’ll be promoted to a new job
for which you are highly unqualified.
Automating repetitive operations
If you need to perform the same action on, say, 12 different Excel workbooks,
you can record a macro while you perform the task on the first workbook and
then let the macro repeat your action on the other workbooks. The nice thing
about this is that Excel never complains about being bored. Excel’s macro
recorder is similar to recording sound on a tape recorder. But it doesn’t
require a microphone.
Creating a custom command
Do you often issue the same sequence of Excel menu commands? If so, save
yourself a few seconds by developing a macro that combines these commands
into a single custom command, which you can execute with a single keystroke
or button click.
13
Chapter 1: What Is VBA?
05_046746 ch01.qxp 1/12/07 6:16 PM Page 13