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