Any good VBA Object Orientated / Class Programming Tutorials

[mdlueck]

I visited a friend last evening who is doing very advanced things in Excel. They are yet to discover the power of Classes.

I knew class based programming before using Access / VBA. So I learned using other tools.

I just checked and nothing clear / concise jumped out at me on the Internet as far as a tutorial for VBA.

Can anyone suggest some VBA materials to help my friend have the OO-AhhHaa moment? TIA!

 

[vbaInet]

There are poor materials on VBA classes on the net but I think there are some good books out there.

If you already know OOP programming then you can use Chip Pearson's website as a reference. Search for "Chip Pearson VBA Classes".

You can always ask us if there's anything in particular you would like to know.

 

[mdlueck]

My friend took class programming 20 years ago, in C++, having to deal with tracking pointers to memory... yuck! Not very relevant to VBA.

Thank you for the reminder about "Chip Pearson VBA Classes" --> http://www.cpearson.com/excel/classes.aspx I had discovered that site while researching for my global application error handler routine.

Noted the suggestion for hard copy books. I will try to research online, and if I come up with any helpful books I will reply to this thread.

 

[vbaInet]

You want the O'Reilly ones. I've seen some but I can't remember their names. The more comprehensive the book the more chance of it having Classes mentioned.

 

[Rx_]

This is a really great point that you make.
How many of us would it take to request an additional Category Thread for CLASS PROGRAMMING ?

Classes are very powerful and I myself need to start using it more. If there was a place to find samples and post questions, my guess is that it would become popular.

FYI: Microsoft Partner (MAPS) Training search on VBA
"We did not find any results for vba"

The MAPS Overview of Microsoft Office 2010 Development.pptx (powerpoint) fails to mention even the basics of what a MS Access Developer Community uses. They seem to leave out the licensing fees of all the high-end tools promoted. It would seem to promote a sledgehammer approach to a finishing nail.

http://msdn.microsoft.com/en-US/office/ff688774