VBA Classes - The Definitive Guide

Рет қаралды 34,467

3 жыл бұрын

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!

Пікірлер: 39

@Uncle_Theodor 2 жыл бұрын

Thank you from Ukraine. I searched for this in the Russian-language KZfaq 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.

@angeladrovermartinez2135 2 жыл бұрын

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

@databen7194 2 жыл бұрын

Thank you!

@seamushand8439 3 жыл бұрын

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

@databen7194 3 жыл бұрын

Thanks Seamus :)

@aNDy-qh1em 3 жыл бұрын

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.

@thearchibaldtuttle 3 жыл бұрын

Nice, thank you!

@SimpleExcelVBA 3 жыл бұрын

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!

@joukenienhuis6888 Жыл бұрын

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.

@amorbatna2725 Жыл бұрын

يعطيك الصحة بارك الله فيك

@marekchudy8893 Жыл бұрын

Thank you.

@shiva11112 3 жыл бұрын

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

@julianevans2256 Жыл бұрын

Excellent tutorial, very well explained

@ukBenuk Жыл бұрын

Thanks Julian :)

@marekchudy8893 3 жыл бұрын

Thank you. :-)

@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.

@orange1826 3 жыл бұрын

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.

@databen7194 3 жыл бұрын

Sorry I no longer develop in Access. You are right; this video transfers 100% across to Access as well. Access VBA has it's own set of Access objects and it will be harder to visualise the objects in a database compared to a worksheet, so I recommend learning in Excel first.

@freeliberalminds Жыл бұрын

This is hilarious and totally explained. Thank you Ben.

@databen7194 Жыл бұрын

Thanks!

@engrvarsi3774 3 жыл бұрын

Thanks

@databen7194 3 жыл бұрын

You're welcome!

@bigt95nt011037 2 жыл бұрын

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

@lorenzogaruglieri7046 2 жыл бұрын

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

@hosseinmolhem3118 5 ай бұрын

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

@chrisk.2957 4 ай бұрын

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.

@henrikijonkoping4694 3 жыл бұрын

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

@thearchibaldtuttle 3 жыл бұрын

Could it be this one? kzfaq.info/get/bejne/qMBpac2DxN-Yl40.html&ab_channel=DataBen

@henrikijonkoping4694 3 жыл бұрын

@@thearchibaldtuttle Thank you, i will check it out

@alexlev8815 2 жыл бұрын

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?

@databen7194 2 жыл бұрын

Hi Alex, well you may want to do much more instead of just setting a public variable. I kept the examples in the video simple, but there's nothing stopping you expanding on them: For example in Let you could do some checks first, maybe an if statement to check the name of the animal does not exceed 30 characters, or do a check that the cats age is not over 100 years old. Your Let checks can go on for as long you like! For the get, you may want to do a calculation first, for example instead of just saying 'meow' you could randomise the result with some extra code so the cat says 'meow', 'purrr', 'hiss' and so on to add some variety. Again impossible with a simple public data type. You can expand your set-get-let's as much as you like and get as interesting as you want, while the public variables are simple data types only: strings, integers and so on. I hope these examples help, good luck!

@alexlev8815 2 жыл бұрын

@@databen7194 Thank you! Now it became much more clear to me.

@userme2803 3 жыл бұрын

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

@databen7194 3 жыл бұрын

Hi Userme, VBA is built upon OOP principles like many other programming languages, so once you understand OOP, you understand the fundamentals of VBA and how you interact with it will be clearer. For a great answer on VBA and OOP principles see: stackoverflow.com/a/31861832/15011558

@user-yq7cm6ln1m 4 ай бұрын

I don't see you using the Animal interface!

@LokeshKumar-yi3ln 3 жыл бұрын

Could you please share the code..

@kimfucku8074 3 жыл бұрын

Check his next video, the download link is in the description kzfaq.info/get/bejne/qMBpac2DxN-Yl40.html&ab_channel=DataBen

@hichamhadj9640 2 ай бұрын

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 😂

@Stache987 Жыл бұрын

Just wait till you own pets, one cat of four here doesn't like toys, just pet treats and doesn't give up the cheek rubs until you give him enough, he almost never meows, at first I thought he was mute, then one day at the back door he did. Another is a theif, you'll wake up to a roll of toilet paper all unrolled and in fragments of pieces, so you have to hide it in cabinets, as for cabinets we had to put child locks on the cabinet under the kitchen sink, they learned how to open it, and there's chemicals that could harm them. One is so stupid he likes his little pot pom balls and likes to play catch. The last cat won't let daddy out of his sight, and is usually against him. As for dogs, I've had two that were so faithful they lived a fu natural life, you could shake the keys and say ride and they will beat you to the car. I've only had one dog learn how to get out of the kennel, he loved to run, and a anonymous neighbor hit him and brought him home for a burial. I tried living without a pet, even worked weekly at a shelter just to love on them. Sorry for rant.. but the discussion just brought it on.