In This Chapter
This chapter presents an introduction to class modules and includes several examples that might help you better understand this feature and give you ideas for using class modules in your own projects.
An introduction to class modules
Some typical uses for class modules
Examples that demonstrate some key concepts related to class modules
For many VBA programmers, the concept of a class module is a mystery, even though this feature has been available in Visual Basic for several years — it was added to Excel beginning with Excel 97. The examples in this chapter may help to make this powerful feature less mysterious.
A class module is a special type of VBA module that you can insert into a VBA project. Basically, a class module enables the programmer (you) to create a new object class. As you should know by now, programming Excel really boils down to manipulating objects. A class module allows you to create new objects, along with corresponding properties, methods, and events.
At this point, you might be asking, “Do I really need to create new objects?” The answer is no. You don’t need to, but you might want to after you understand some of the benefits of doing so. In many cases, a class module simply serves ...