Chapter 4

Introducing the Excel Object Model


Bullet Introducing the concept of objects

Bullet Finding out about the Excel object hierarchy

Bullet Understanding object collections

Bullet Referring to specific objects in your VBA code

Bullet Accessing or changing an object’s properties

Bullet Performing actions with an object’s methods

Everyone is familiar with the word object. Well, folks, forget the definition you think you know. In the world of programming, the word object has a different meaning. You often see it used as part of the expression object-oriented programming, or OOP for short. OOP is based on the idea that software deals with distinct objects that have attributes (or properties) and can be manipulated. These objects are not material things. Rather, they exist in the form of bits and bytes.

In this chapter, you’ll be introduced to the Excel object model, which is a hierarchy of objects contained ...

Get Excel VBA Programming For Dummies, 5th Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.