Class Modules

[mark]

Please post any comments, links, or suggestions for
reference sources on getting started with class modules.

thanks.

 

[Robin Hammond]

Mark,

This isn't a tutorial, but if you want to look at an example of using a
class module, my progress bar class is fairly simple and should give you an
indication of how you might get started.

http://www.enhanceddatasystems.com/ED/Pages/ExcelProgressBar.htm

Robin Hammond
www.enhanceddatasystems.com

 

[Bob Phillips]

Hi Mark,

Here's a good one

http://www.microsoft.com/AccessDev/Articles/GetzCh3.HTM

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[mark]

Thanks, I'll look at it.

 

[onedaywhen]

Hmm... I just took a glance at that one and the section 'Disadvantages
of Collection Classes' is 100% incorrect: it *is* possible in Office
VBA to specify the default method for a custom class and it is easy to
get For Each loop to work with collection classes.

 

[mark]

Robin,

For some reason, your original message now comes up and
says 'Message unavailable'... I had seen your note, but
hadn't copied out the link that you posted.

Would you post the link to your progress bar class module
example again, please?

Thanks.

 

[Robin Hammond]

I can still see it on my system, but here you go...

http://www.enhanceddatasystems.com/ED/Pages/ExcelProgressBar.htm

Robin Hammond
www.enhanceddatasystems.com

 

[Bob Phillips]

Jamie,

Are you suggesting from that remark that this is not a good article? If so I
think you are wrong, if not, your response is disingenuous at the least. Ken
Getz and Mike Gilbert are 2 highly respected authors in the VBA field, and
they have helped many to benefit from their knowledge. This article was
written in 1996, and still holds as a great free article that addresses the
OPs question.

Also, the article says that '... Perhaps ... VBA In Office will support
default methods for custom classes .... I would venture that this is
correct. Yes, we all know that you can frig a default, but that is not
built-in support. Perhaps you do, but I don't know how to specify a default
in VBA (I don't consider Notepad to be part of VBA). And I doubt that this
frig was known in 1996.

Bob