Excel vba class module tutorial 2024

preview_player
Показать описание
Learn how to create and master Excel VBA Class Modules and Object Oriented Programming using Excel Visual Basic For Applications.




DISCLAIMER: This video and description contains affiliate links, this means if you click on one of the product links, I’ll receive a small commission.
If you do use one of the links, thanks I appreciate it.
Рекомендации по теме
Комментарии
Автор

This was so helpful!! Every project I work on from now on will function better and look a million times cleaner.

billydoespranks
Автор

Thank you for the awesome video. Classes are very difficult to understand for me but am slowly getting there.

m-squaredcontractors
Автор

Thanks for the tutorial. There are 4 subtopics related to the VBA OOP also difficult to understand. 1) filling classes with Dictionaries 2) Interfaces and their implementation 3) using custom Type variables within a class variable 4) more in general, how to manage classes as properties within other classes.

alessandromarzatico
Автор

From my own investigation, classes are a starting point for something a lot more complex: object oriented programming.

OO has been covered by many but only using languiages such as C#, Java and Python.

Would you be creating more videos, explaining concepts such as the SOLID principles and the 23 design patterns purely from a VBA persepctive (admittedly any design pattern requiring inheritance would not be avialble in VBA)?

chess-sq
Автор

Nice video with clear explanations. However

when writing a program from scratch, one won't have the luxury of being told beforehand:

1. How many classes that would be needed to be created
2. What each one would be doing
3. How one class might relate to another class or classes

So what would be useful is if you could create another video outlining the steps BEFORE any code is written, ie the thought proocess, how might one plan things (which I believe is called Data Modelling).

noviceprogrammer
Автор

Thank you for the video. This is helping to get me closer to understanding classes. I work in MS Access, not usually in Excel.
Can you possibly do a video on classes in Access?

bumpersmith