Excel® 2013 VBA and Macros

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

Using Collections to Hold Multiple Records

Using User-Defined Types to Create Custom Properties

Next Steps

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