Chapter 14. Interfaces

In previous chapters, we explained class modules and the various parts they can play in our applications in some depth, including handling events, encapsulating functionality, and creating our own object models. We’ve also seen that UserForms and the workbook and worksheet code modules are just special types of class module.

This chapter takes a step further into object oriented design by explaining how one class can appear to be many different types of object and how many different classes can appear to be the same type of object. By using the techniques explained in this chapter we can improve the robustness of our solution, simplify the development experience, and reduce the amount of code we need to write. As an example, ...

Get Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.