Chapter 3: The VBA Object Model

VBA is essentially object driven. Excel, for example, provides dozens of objects that can be manipulated. This includes workbooks, worksheets, ranges, charts and images, and shapes. These objects are arranged in a hierarchical structure. If you want to do anything in VBA, understanding the VBA object model is essential. The recipes in this chapter will be your reference to understanding and working with objects in VBA.

In this chapter, we will cover the following recipes:

• Understanding and identifying objects in VBA
• Objects as a collection, and changing the attributes of the entire collection
• Modifying object properties
• Associating methods with objects
• Using events to activate objects
• Using the Object Browser in the VBA Editor

By the end of this chapter, you will be able to work with objects in VBA.