About Objects and Collections

If you've worked through the first part of this chapter, you have an overview of VBA and you know the basics of working with VBA modules in the VBE. You've also seen some VBA code and were exposed to concepts like objects and properties. This section gives you some additional details about objects and collections of objects.

When you work with VBA, you must understand the concept of objects and Excel's object model. It helps to think of objects in terms of a hierarchy. At the top of this model is the Application object - in this case, Excel itself. But if you're programming in VBA with Microsoft Word, the Application object is Word.

0 0

Post a comment