Chapter 4. Introducing the Excel Object Model
Discover the Excel Object Model
Objects are the individual pieces of an application. For example, a worksheet is an object, a range of cells is an object, and a chart is an object. You can use the Excel object model to interact with objects. Using the object model, you can access everything from the entire application to an individual cell in a worksheet.
Objects can have properties and methods. You use methods to perform actions on objects, such as move an object. You use properties to change the characteristics of an object, such as the color of an object.
Excel has an enormous number of objects, properties, and methods, and remembering all of them is virtually impossible. Luckily, the VBE provides ...
Get Excel® Programming: Your visual blueprint™ for creating interactive spreadsheets 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.
