VBA Classes - The Definitive Guide

End to end coverage of using interfaces, classes and objects in VBA! This is exactly what VBA was designed for and if you can learn this you will supercharge your VBA powers. Let’s get to it!

[Uncle_Theodor]

Thank you from Ukraine. I searched for this in the Russian-language YouTube segment, but unfortunately I couldn't find anything suitable there. Found in this video. Quite a simple and handy explanation for the topic I'm looking for.

[julianevans]

Excellent tutorial, very well explained

[angeladrovermartinez]

Hey Ben, great job. It approches the topic conceptually with a very useful template. Thanks to people like you!

[seamushand]

Good explanation - i especially liked the walk through of the creation of the cat object from the cat class showing the constructor etc.

[aNDy-qhem]

Hi, thanks, very detailed explanation!
'On Error Resume Next' seems to be not nice practice as in the runtime there could be other error passing by which should not be disregarded.
IMHO it would be nicer to have 'Sound' method inside Animal interface that would bark for the dog and meou for a cat instance.

[shiva]

Excellent knowledge and presentation, is this possible to apply inheritance of classes from other classes (not interfaces) in VBA

[SimpleExcelVBA]

Really good example for interfaces and classes use. This could be also in shorter version for not as patient people as me :D Anyway, good effort!

[joukenienhuis]

Great explanation of object oriented coding. I only don’t see the use with Excel in this example, only just to get to the vba screen.

[LuisBreak]

Great tutorial. Very helpful. Thanks!!! I was wondering two things. 1. Should we avoid On Error Resume next since it is not a good practice and instead having a common method called Animal.Sound() that will be implemented by each Specific Animal? 2. Should the variable animal be declared as Animal Type instead of Variant? Is that possible? In other languages that would be more appropriated, since Variant would accept Any type and that would cause an error in the code for sure.

[freeliberalminds]

This is hilarious and totally explained. Thank you Ben.

[orange]

Very clear video, thanks. Do you do any work with Access?There are few
videos on class modules and Access. I realize that your samples use vba
and are not necessarily limited to excel.

[hosseinmolhem]

Dear Ben,
Thanks for sharing knowledge. let me know how can access to your code?

[chrisk.]

Thank you Ben! In the Loop for the Debug.Printing (animal.Name) I get a runtime error 438 (without error handling, otherwise it stays blank). Any idea? Thanks.

[userme]

can you tell me why I need to learn Object oriented concept before or as a prerequisite to learn VBA? Can you give me an example from real life as an analogy so I can understand it better? Thank you

[lorenzogaruglieri]

hi, the video is really exhaustive.
A question if possible:
I am trying to use, almost like in your example, a property which is a collection, but which is not private but is also present in the interface. I am only getting errors such as "invalid argument".
It is possible to implement a collection in an object that implements an interface.

Thanks in advance.

Lorenzo

[henrikijonkoping]

Good Ben, what is the name of the next video to this? This was very intersting

[bigtnt]

I don't suppose there examples of the lecture that can be downloaded?

[alexlev]

Hi, Ben! Why do we need to use Get-Let-Set statements to add properties to class if we can just use Public variables in classes?

[عليعلي-نخص]

I don't see you using the Animal interface!

[hichamhadj]

Excellent toturial, I only wish the examples were more practical like contacts, orders, forms... Etc, instead of cats and dogs. Don't get me wrong, I love cats 😂