Objects and user-defined types

[davidd31415]

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

[malik641]

I couldn't find much either, but I did find this:

User-defined Data Types

I also have a book on VBA programming, called
Microsoft Excel 2000 Power Programming with VBA by John Walkenbach

Great read, covers a lot of info. It talks about User-Defined Data Types for a page and the website I gave you says basically the same thing as this section of the book. Another thing I don't like about the book (as well as the internet) is the fact that I can't find ANY types of guides on Shape Methods, Properties, and manipulation of shapes.

Hope this gets you started in the right direction

[DKenny]

The page is on Collections/Classes - but still maybe useful to you.

Using Custom Collections in Microsoft Access