Excel 2016 VBA and Macros

9. Creating Classes and Collections

In This Chapter

Inserting a Class Module

Trapping Application and Embedded Chart Events

Creating a Custom Object

Using a Custom Object

Using Collections

Using Dictionaries

Using User-Defined Types to Create Custom Properties

Next Steps

Excel already has many objects available, but there are times when the job at hand requires a custom object. 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 also be used to trap application events, embedded chart events, ActiveX control events, and more.

Collections are a variable type that can ...