Excel VBA Using Class Modules in Other Projects

Excel VBA Introduction Part 36 – Using Class Modules in Other Projects


One small limitation of VBA Class Modules is that, by default, you can only use them in the VBA Project in which they were created. This video explains how you can make your class modules available to other VBA projects. You’ll learn about the Instancing property of a class, how to set references to VBA projects, how to write a function to return a new instance of a class and how to create an Excel Add-In as a convenient way to distribute your class modules.

Be the first to comment

Leave a Reply