Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365)

Chapter 9

Creating classes and collections

In this chapter, you will:

• Learn how to insert a class module

• Trap application and embedded chart events

• Create and use a custom object

• Learn various methods of creating collections

• Minimize the use of repeated code by using a collection

• Learn about dictionaries

• Create custom properties with user-defined types (UDTs)

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