Page 55 - Excel Progamming Weekend Crash Course

d540629 ch02.qxd 9/2/03 9:27 AM Page 30

30 Friday Evening

REVIEW
The VBA Editor provides you with a powerful “command center” for developing your Excel
projects. More than just a code editor, it also has tools for organizing the components of
your project and setting object properties. Some of the Editor’s more specialized capabilities
are covered in subsequent sessions. Some important things you learned in this session are:
VBA code is organized in procedures, which are located in modules.
The Project Explorer enables you to view the contents of your project and add new
modules.
You can reuse code by exporting a module from one project and then importing it
into another.
The Editor has several convenience features that improve the speed and accuracy of
code editing.
You use the Property Window to view and set an object’s properties.
Excel macros are recorded as VBA code and can be helpful aids in programming.
The VBA Editor has an online help system that provides information on the VBA
language, the Excel object model, and the Editor itself.

QUIZ YOURSELF
1. Where does the VBA Editor store your code? (See the “Code and Project
Organization” section.)
2. What are the three choices for locating code in a VBA project? Which of these
three should generally be used? (See the “Code and Project Organization” section.)
3. How can you share code between projects? (See the “Importing and Exporting
Modules” section.)
4. The VBA Editor offers several optional features, such as Auto Syntax Check, that
can assist with your code editing. How do you turn these options on and off? (See
the “Editing Tools” section.)
5. In the Property Window, how do you set an enumerated property? (See the “The
Property Window” section.)
6. How do absolute cell references differ from relative references? (See the “Cell
References in Macros” section.)