Creating Classes Records and Collections

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 class modules. They are specific to the object with which they are associated and contain events.

Class modules are used to create custom objects with custom properties and methods. They can trap application events, embedded chart events, ActiveX control events, and more.

0 0

Post a comment