O'Reilly logo

Excel VBA Programming For Dummies, 5th Edition by John Walkenbach, Michael Alexander

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 4

Introducing the Excel Object Model

IN THIS CHAPTER

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required