Creating Classes in VBA
HTML-код
- Опубликовано: 8 июл 2024
- 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.
_____________________________________________________________________
Classes (OOP) is an advanced topic in VBA. My introductory VBA video, which steps you through writing your first VBA program, is available here: • Hello, World! - Introd...
_____________________________________________________________________________________
If you appreciate my content, please support this channel by donating on my website: sayrhymes.com/donate/
#JenniferGarthVBA #vbatutorial 
Наука
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.
I think this is the clearest overview of VBA classes I've seen.
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” (ruclips.net/video/yZunjzEV4rA/видео.html). 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!
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 !
The way you explained "New" class was fantastic. ❤❤❤.
Thank you.
this has been the best video on creating class modules and objects yet, easy to understand thanks
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!
Thanks so much Jen! Loved your class! Keep it up!
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.
Thank you for the feedback, I appreciate it! Please see my pinned comment about a new video I have just uploaded.
Great video, love the description
Explained nicely, thank you, cheers
nice, well-explained, real-life coding, beautiful voice
TIL that onlyfans is for content creators in general, not only for THAT kind of content 😂 Thanks, clear and straightforward explanation, subscribed!
Your way of explanation is so good that it makes the concepts easily understandable, waiting for more videos on VBA.
Thank you for this video
Great way of explaining things. Really good. I´m looking forward to future videos. 😀
Excellent explanations please keep it and post more videos.. 👍
Classy lady 👍
Vídeo muito bom. Obrigado!
Thank you, I appreciate it! Please see my pinned comment about a new video I have just uploaded.
Gee, I have been writing basic macros for quite some time and was not aware of this at all.
Thank you very much for making this so easy.
Glad it was helpful!
muy bueno el video
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
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!
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.
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?
Why don't you keep posting videos? Your first one was excellent.
Thank you for the feedback, I appreciate it! Please see my pinned comment about a new video I have just uploaded.
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
Nice video lesson complete and detailed. Good job Jennifer.
Debug.Print Fluffy says "Cool"
Debug. Print Fickles says " and interesting video" 👋😉