Page 171 - Excel Data Analysis

10 537547 Ch09.qxd 3/4/03 12:13 PM Page 157

AUTOMATING ACTIONS WITH MACROS 9

VISUAL BASIC EDITOR

You write the Visual Basic for Applications, or VBA, code contains project information. The Visual Basic Editor
required to create complex macros using the Visual remembers the window locations that you set up each
Basic Editor, accessible via all Microsoft Office time you open it. By default, not all windows are
applications, including Excel. Arranged in a series of displayed when you initially open the Visual Basic
windows, which you can move around with your mouse Editor, but you can select the windows that you want to
to obtain the desired development layout, the VBE view from the View menu.

OBJECT LIST BOX
Lists objects associated
with the selected project.
PROCEDURE LIST BOX
PROJECT EXPLORER Lists the procedures
Displays a list of the open associated with the
projects and selected object.
corresponding modules,
objects, and forms, using
different nodes to
represent each item type.
CODE WINDOW
Displays the VBA source
code in the selected module.

IMMEDIATE WINDOW
PROPERTIES
WINDOW Provides immediate results
for statements typed in
Displays properties for the the window.
currently selected object.

LOCALS WINDOW WATCHES WINDOW
Shows values of local Shows the set watches
variables during debugging. during debugging.

157