Creating Classes in VBA

[@natcain]

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

[@stephenhammond1745]

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.

[@itzm1kea]

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

[@anti-sheep-machina6548]

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…

[@mazemimovie]

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

[@charleswebb3520]

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!

[@jmathew6988]

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.

[@Jennifer_Garth]

Thank you for the feedback, I appreciate it! Please see my pinned comment about a new video I have just uploaded.

[@Jennifer_Garth]

Due to recent feedback in the comments, I am considering adding more videos to this channel and putting more time into creating more content. I have posted another video, “Getters and Setters in VBA” (kzbin.info/www/bejne/r4vYn52wertnqKM). Any feedback you can give on this video will be greatly appreciated and help me decide if I should continue or if I just had a little bit of a one hit wonder. 😊 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!

[@scouter-xn6zi]

Jennifer, I recently ran across your channel and your work is very good - you should definitely add more videos. Your explanations really stand out. Thank you for your work !

[@anshulm4140]

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

[@gregbad78]

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

[@ElWiwif]

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

[@jeyapauldavid5596]

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

[@leegarrett1908]

Great video, love the description

[@gahshunker]

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

[@hakanlund9074]

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

[@Garrettm31]

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

[@rrrraaaacccc80]

Great 💯👍

[@janezklun]

Explained nicely, thank you, cheers

[@jitendrashelar4123]

Thank you very much for making this so easy.

[@Jennifer_Garth]

Glad it was helpful!

[@icandodgebullets86]

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!

[@TYoung023]

The only time I used one (so far) with my limited knowledge of classes, is on a userform with 15 text boxes. It creates a group of all 15 so I can trigger a change event if all have been filled out. I admit that I borrowed the code from google university and, now that I’ve watched this video, I’ll be revisiting that project to better understand how it really works. I’m going to be developing some applications in Excel and eventually Access in the near future and I can see where this would certainly make the code clearer. Thinking of a phone directory with clsPerson with .name, .dept, .extension, etc. where the user can add, modify (get/let), and delete a listing.

[@robsonrocha8600]

Vídeo muito bom. Obrigado!

[@Jennifer_Garth]

Thank you, I appreciate it! Please see my pinned comment about a new video I have just uploaded.

[@weibinren92]

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

[@Jennifer_Garth]

Thank you for the feedback, I appreciate it! Please see my pinned comment about a new video I have just uploaded.

[@freeliberalminds]

Nice video lesson complete and detailed. Good job Jennifer.

[@joukenienhuis6888]

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?

[@tryscience]

Classy lady 👍

[@gregbernard7861]

Gee, I have been writing basic macros for quite some time and was not aware of this at all.

[@yosef-yosef9414]

Thank you for this video

[@truthseeker9988]

👍👍👍

[@shep7484]

Was able to follow explanation but disappointed that you didn't bother to show how to do the replace command or run the sub after it was entered. You showed it being run from the spreadsheet but I was only able to run it from the vba editor after playing around for some time. And ir would have been nice to see how it could have been used in the spreadsheet. I probably didn't understand this tutorial was not meant for beginners. Jerry

[@bot6731]

muy bueno el video

[@lazyreviewssupport9811]

Debug.Print Fluffy says "Cool" Debug. Print Fickles says " and interesting video" 👋😉