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

Get Microsoft Excel 2019 VBA and Macros, First Edition 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.

Start your free trial