Microsoft Excel 2002 Visual Basic for applications step by step / Reed Jacobson.

Part 1 Automating Everyday Tasks
1 Make a Macro Do Simple Tasks
How visual Basic for Application Talks to Excel
Creating a Simple Macro
Changing Multiple Properties at Once, etc.


2 Make a Macro Do Complex Tasks
Divide and Conquer
Task one: Opening the Report File
Task Two: Filling in Missing Labels, etc.


Part 2 Exploring Objects
3 Explore Workbooks and Worksheets
Understanding Workbooks
Understanding Worksheets
4 Explore Graphical Objects
Exploring Graphical Objects
Exploring Chart Objects

4 Explore Range Objects
Referring to a Range
Formatting a Range
Entering Values and Formulas unto a Range, etc.

6 Explore Pivot Table Objects
Building Pivot tables
Refining Pivot tables

Part 3 Exploring Visual Basic
7 Control Visual Basic
Using Conditionals
Creating Loops
Managing Large Loops

8 Extend Excel and Visual Basic
Creating Custom Functions
Handing Errors

Part 4 Making Macros Easy to Use
9 Launch Macros with Events
Creating Custom Toolbar and Menus
Creating Custom Command Buttons
Handling Worksheet and Workbook Events

10 Use Dialog Box Controls on a Worksheet
Using a Loan Payment Calculator
Creating an Error-Resistant Loan Payment Calculator, etc.

11 Create a Custom Form
Creating a Form's User Interface
Preparing a form's Functionally
Implementing a form

12 Create an Enterprise Information System
Examining an Existing Enterprise Information system
Charting Data from a Database
Controlling the Report with Macros, etc.

Includes Index: p 293-306