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 ...
Get VBA Automation for Excel 2019 Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
