VBA Class Modules (2000)

[AlanMiller]

I'm looking for tutorials and examples of VBA Class code. I'm just moving into this area and find the examples given in the Help files a little too simplistic for learning purposes. I found a neat example of a Progress Bar for Excel, using a lot of API functionality, but other than that, no luck.

Any leads (Excel and Word VBA in particular) appreciated.

Alan

[unkamunka]

This 60 odd page chapter on VB Classes is perhaps off-topic, but it should be able to give you some ideas. Most of it is pretty clearly written; although it does get muddy from time to time. HTH

[AlanMiller]

Many thanks for that <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15>. It does look nicely written and I look forward to a long read.

Edited - I'm about half way through this now and find it an excellent piece for someone who already has an OO background in C++, but needs to know about the "peculiarities" of the VB approach to OOP. I might even buy the whole book! <img src=/S/wink.gif border=0 alt=wink width=15 height=15>

Alan