Object Oriented Programming in VBA

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pcb_svp@telenet.be - 14 Nov 2007 19:49 GMT

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

Reply to this Message

Jay Freedman - 14 Nov 2007 21:54 GMT

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

Signature

Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

> Hello,
>
[quoted text clipped - 7 lines]
>
> David

Reply to this Message

JP - 14 Nov 2007 23:53 GMT

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

On Nov 14, 2:49 pm, pcb_...@telenet.be wrote:

> Hello,
>
[quoted text clipped - 7 lines]
>
> David

Reply to this Message