Chapter 4 Objects and Collections

Objects are the fundamental building blocks of Visual Basic; nearly everything you do in Visual Basic involves manipulating objects. Every element in Microsoft Excel — each workbook, worksheet, chart, cell, and so on — can be represented by an object in Visual Basic. By creating procedures that manipulate these objects, you automate tasks in Microsoft Excel.

Contents

• Introduction to Objects
• Building an Expression to Return an Object
• Applying Properties and Methods to an Object
• Using Microsoft Excel Objects
• Using the Object Browser