Chapter 1—Introduction
What Is VBA?
A Brief History of VBA
What Can You Do with VBA?
Object Models: The Power of Programming with VBA
Chapter 2—Program Structure
Getting a VB Program to Run
The Structure of a VB Program
Ending Your VB Program
Chapter 3—VBA Variables and Data Types
Visual Basic Data Types
Type Conversion
The Variant
Declaring Variables and Constants
Array Variables
User-Defined Types
Variable Scope and Lifetime
Object Variables and Binding
Passing Parameters
Intrinsic Constants
Chapter 4—Class Modules
Properties
Enumerated Constants
Class Module Events
Implementing Custom Class Methods
Creating ActiveX Components
Using ActiveX Components in a Project
Chapter 5—Automation
Creating Object Model References
Reading the Object Model
Working with the Object Model
Collection Objects
Trapping an Automation Server’s Events
Automation Examples
Automation Performance Tips
Chapter 6—Error Handling
Building a Robust Application
Error Handling in Procedures
Error Handling in ActiveX Servers
Reporting Errors
Part II: Reference
Chapter 7—The Language Reference
Part III: Appendixes
Appendix A—Language Elements by Category
Appendix B—Language Constants
Appendix C—Operators
Appendix D—What’s New in VB6?
Index