Business Solutions VBA for the 2007 Microsoft Office System

5Working with Objects

IN THIS CHAPTER

What Is an Object?

The Object Hierarchy

Working with Object Properties

Working with Object Methods

Handling Object Events

Working with Object Collections

Assigning an Object to a Variable

The Is Operator

Working with Multiple Properties or Methods

Example: The Application Object

Example: The Window Object

Many of your VBA procedures will perform calculations using simple combinations of numbers, operators, and the host application’s built-in functions. You’ll probably find, however, that most of your code manipulates the application environment in some way, whether it’s formatting document text, entering data in a worksheet range, or setting application options. Each of these items—the document, ...