VBA and Macros for Microsoft Excel

20Creating 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

Collections

Case Study: Help Buttons

User-Defined Types (UDTs)

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.

You've already had some experience with class modules. In the VBE, the workbook, worksheet, chart, and userform modules are all types of enhanced ...