Home > Sample chapters

Adding Functionality with Classes in Microsoft VBA

Summary

In this chapter, you learned about classes via two examples. In the first example, you saw how a general purpose framework for working with form Tab controls can dynamically load subforms and be re-written using classes. The final result was simplified application code with the complexity hidden within the class.

The second example introduced techniques for building a hierarchy of classes by using a base class and several derived classes. This provides a more structured and maintainable solution when using classes.