Chapter 4

Introducing the Excel Object Model

In This Chapter

arrow Introducing the concept of objects

arrow Finding out about the Excel object hierarchy

arrow Understanding object collections

arrow Referring to specific objects in your VBA code

arrow Accessing or changing an object’s properties

arrow 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, I introduce you to the Excel object model, which is a hierarchy of objects contained ...

Get Excel VBA Programming For Dummies, 3rd Edition 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.