IN THIS CHAPTER
Introducing the concept of objects
Finding out about the Excel object hierarchy
Understanding object collections
Referring to specific objects in your VBA code
Accessing or changing an object’s properties
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 ...