Automation Using Visual Basic Applications (VBA) 159
FIGURE 10.4 The Properties window
changes the characteristics of items in
the VBE.
Starting a module with Sub indicates the beginning of a subroutine, the name
PrintOutput is a user created description of the subroutine, followed by an open
and close parenthesis. After entering this code and pressingEnter, the VBE will
automatically enter End Sub, indicating an end to the subroutine. Press a few
hard returns after the Sub PrintOutput() so that there is space to enter the main
body of code between that beginning and End Sub. The End Sub code should
always be at the end.
- The next step is to turn off screen updating, which displays the results of the
macro as it is running. Screen updating slows down a macro considerably, so in
most cases it should be turned off. Under the previous code enter:
Application.ScreenUpdating = False
This line of code is a perfect example of object/method interaction. The appli-
cation is the object, which is affected by the screen updating method. Writing
the object followed by a period and then the method is a typical object-oriented
programming convention.
- The main part of a print macro is designating the range to be printed, the correct
page set up, and ordering the print. Under the previous code enter:
Sheets("Output").Select
Range("A1:P57").Select
