VBA and Macros: Microsoft® Excel® 2010

22. Creating Classes, Records, and Collections

IN THIS CHAPTER

Inserting a Class Module

Trapping Application and Embedded Chart Events

Creating a Custom Object

Using a Custom Object

Using Property Let and Property Get to Control How Users Utilize Custom Objects

Collections

User-Defined Types

Excel already has many objects available, but there are times when a custom object would be better suited for the job at hand. You can create custom objects that you use in the same way as Excel’s built-in objects. These special objects are created in class modules.

Class modules are used to create custom objects with custom properties and methods. They can trap application events, embedded chart events, ActiveX control events, and more.

Inserting a Class ...