O'Reilly logo

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft® Excel and VBA® by John Green, Rob Bovey, Stephen Bullen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 11. Interfaces

The previous few chapters have explained class modules in some depth and the various parts they can play in our applications—handling events, encapsulating functionality and creating our own object models. We've 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. We show that 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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required