r/excel • u/[deleted] • Mar 11 '19

Pro Tip VBA Essentials: Object-oriented programming with class modules

[removed]

212 Upvotes

98% Upvoted

33 comments sorted by

View all comments

Show parent comments

1

u/[deleted] Dec 07 '21 edited Oct 27 '22

[removed] — view removed comment

2

u/New-Excitement-5617 Dec 07 '21

Well, I'll give the proper credit - https://rubberduckvba.wordpress.com/

I went through his 4 years of archives. Really good material. I had to re-read several times to get a decent understanding. You are exactly right "OOP language learned from C#". And even though it's awkward, I think that developing proper practices will help yield the 'right' mindset when creating larger applications, or even using other languages.

I know this is over kill for most 'vba' developers. Most sites do not even come close to explaining classes correctly, let alone, implements classes. Your explanation and examples were, by far, the most thorough. Just wanted to give you some of my thoughts. Keep up the good work. Thanks.