I've been using VBA to analyze raw data and create Excel reports for about a year now. While also moving from C to C++ I've been learning the advantages of object-oriented programming.

Online VBA tutorials have been excellent in learning how to interface with Excel, but when I start looking for information on defining my own types/classes and creating objects I end up googling in circles.

Can anyone recommend a site, tutorial, or even the MSDN articles that would help me get off the ground in this area? I've been using Global variables or passing many variables by reference and I would like to move away from these practices!

Help here would be appreciated as well. I will consider buying a book if it is highly recommended.

Thanks,

David