Object Oriented Programming in VBA

[pcb_svp]

Hello,

Could anyone point me in the direction of a good (free) online
tutorial about VBA? I have already covered the basic topics but I
would like more information about Object Oriented Programming in VBA
like class modules and how to create collections of your own class...
However I find this information very difficult to come by.

Many thanks

David

 

[Jay Freedman]

You're right, there's very little information about classes in VBA. Maybe
this will help:
http://msdn2.microsoft.com/en-us/library/aa165186(office.10).aspx

A particular application of classes in VBA is an event handler. See
http://word.mvps.org/faqs/macrosvba/AppClassEvents.htm

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[JP]

Check out

http://www.cpearson.com/excel/Classes.aspx
http://www.di-mgt.com.au/cl_Simple.html
http://www.dailydoseofexcel.com/archives/2004/09/28/classes-creating-custom-objects/
http://msdn2.microsoft.com/en-us/library/aa140954(office.10).aspx

Sorry for the decidedly Excel-flavored slant.


HTH,
JP