Creating Classes in VBA

Learn how to create classes (class modules) in VBA.

In this video, we'll learn about creating and using classes in VBA.

First, we'll create a class module and write the code for the class. Then we'll instantiate the class and use it to perform some actions.

_____________________________________________________________________

_____________________________________________________________________________________

#JenniferGarthVBA #vbatutorial

[natcain]

I think this is the clearest overview of VBA classes I've seen.

[anti-sheep-machina]

I want to say thank you. Great Videos.

I want use OOP more in my sources. Of course they work without objects, too. But in so many cases it is so an improvement to use objects instead of normal functions.

Greetings from Germany…

[itzmkea]

this has been the best video on creating class modules and objects yet, easy to understand thanks

[mazemimovie]

The way you explained "New" class was fantastic. ❤❤❤.
Thank you.

[stephenhammond]

I have watched a number of videos on creating/using classes in vba and you have provided the clearest explanation that I've heard so far concerning how they actually work. Thanks.

[gregbad]

nice, well-explained, real-life coding, beautiful voice

[jmathew]

OMG! What a marvelous teacher you are.

I have been trying to get an understanding of Excel VBA classes for nearly an year now. I have watched many videos and tutorials before but found it very complicated and difficult to understand. I gave up thinking that I was not not capable or skilled enough for learning this topic. That is until I watched your 10 mins. tutorial.

Thank you very much. Hopefully there will be many more videos from you.

[charleswebb]

So glad to have your video pop up on my 'feed'. Just explaining that properties are like adjectives and methods are like verbs is a wonderful way of getting the point across. Programming is a language after all!

[jeyapauldavid]

Excellent explanations please keep it and post more videos.. 👍

[Jennifer_Garth]

Thank you so much for the kind words and encouragement! Thanks for watching and thanks to those who have subscribed to my channel and liked my videos. If you appreciate the content, please like and subscribe to let me know!

[anshulm]

Your way of explanation is so good that it makes the concepts easily understandable, waiting for more videos on VBA.

[freeliberalminds]

Nice video lesson complete and detailed. Good job Jennifer.

[gahshunker]

TIL that onlyfans is for content creators in general, not only for THAT kind of content 😂 Thanks, clear and straightforward explanation, subscribed!

[ElWiwif]

Thanks so much Jen! Loved your class! Keep it up!

[hakanlund]

Great way of explaining things. Really good. I´m looking forward to future videos. 😀

[jitendrashelar]

Thank you very much for making this so easy.

[Garrettm]

At 8:12 after I change property from public to private for sound the drop down menu of properties doesn’t show up next to the . For me

[icandodgebullets]

I come from a VBA and JS background (Google sheets) originally - I've written plenty of scripts but always in a procedural way. I'm currently doing a post grad in computer science with Java as the main language, where classes are very relevant. My question is, although I see how important classes are, I'm sure why they are necessary for VBA. I'm trying to imagine coding a macro that would need to use classes and interfaces like in Java or building a more complex application. I'd love to hear your thoughts!

[weibinren]

Why don't you keep posting videos? Your first one was excellent.

[joukenienhuis]

Thank you for explaining the basics of object oriented programming with excel, because I think it exceeds VBA coding. But why is it necessary in Excel?