Microsoft® Office Excel 2003 Programming Inside Out

Chapter 4. VBA Programming Starter Kit

Introducing the Visual Basic Editor

Managing Code Windows

Developing Projects with the Project Explorer

Declaring Variables, Constants, and Data Types

Assigning Values to Variables

Working with Arrays

Creating Dynamic Arrays

Writing to the Screen and Accepting Input

Defining Object Variables

Creating Custom Data Types

Controlling Program Flow

Error Handling

Introducing the Visual Basic Editor

The Visual Basic Editor is a powerful tool that lets you extend the power and versatility of macros beyond anything that can be done through recording alone. So that you can fully understand how to use the Visual Basic Editor, this chapter examines all facets of the Visual Basic Editor: what the various components are, what they ...