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

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link www.wiseowl.co... to make a donation. Thanks for watching!
You can buy our Introduction to Excel VBA book here www.lulu.com/s...
By Andrew Gould
www.wiseowl.co.uk - 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.
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!

[@mje01]

This is an excellent set of tutorials and thank you Andrew your style of presentation makes it that bit easier for "old codgers" like myself to follow the content

[@abhishekpandey190]

I have learnt creating and using class module and their scope form this channel video.Very good content and conceptual. Got clear understanding about class module after these two videos. Planning to learn much more form this channel.Thanks a lot and keep creating such kind quality content videos

[@loveroflife2157]

Very useful video again. Amazing tutoring skills you got.

[@janezklun]

Great class, thank you, Cheers

[@WiseOwlTutorials]

Thanks Janez, glad you enjoyed it!

[@12345TNY]

Thank you, you are good teacher!

[@shahimkhlaifat]

classes thing reminds me of one famous meal of china, just hear the name of it 明珠酥鮑 or in English it is "Bright Pearl Abalone" all of these terms and considerations of things can be replaced by just saying "Rice meal" and that's it. after all of these tutorial that I had learned I came to the point that classes are just things that big software companies has created to not let people use their functions alone. every developer I have met, is saying the same thing. Dark Ages programming someone was saying thank you Andrew

[@yehia3amer]

you Know what, you Saved my Life Thanks soooooo much :D

[@nunoponts7951]

u're just awersame !

[@imranbhatti8580]

Hi Andrew. Nice explanation. What if we want to use the class of another instance of Excel?

[@giorgikavtaradze9504]

Hi, can we use a personal macro workbook to store our class modules in rather then using Add-In?

[@davegoodo3603]

Hi Andrew, great video as always. I’m wondering if you know this process with Access, and would you mind pointing me in the right direction please? I’m creating a class in Access that I would like to use in other projects, thanks.

[@davegoodo3603]

WiseOwlTutorials Thanks very much Andrew.

[@cormackeenan8175]

I vaguely remember that you could save a workbook with modules to a particular file type that exposed them to the excel system was I dreaming...

[@Monduras]

so it's all a bit confusing on why you have to create two separate public functions to instance the two classes to the other project? isn't it exactly equivalent to just using set f = new film ??? so confusing why have to add so much code overhead.

[@user12345654]

Instancing property PublicNotCrearable does not allow creating an instance from another project. So, instances of classes had to be created in this way.

[@Dexter101x]

Unfortunately, there's no way in office 365 to do the same, which is unfortunate

[@Dexter101x]

Just found it, its now "Excel Add-ins" rather than just Add-ins

[@WiseOwlTutorials]

@@Dexter101x You beat me to it!

[@Dexter101x]

@@WiseOwlTutorials any chance of tutorial for python in excel? The preview of python is available now in excel

[@WiseOwlTutorials]

@@Dexter101x We might do! I haven't had chance to look at it yet.