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

thanks.

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/E...rogressBar.htm

Robin Hammond
www.enhanceddatasystems.com

"mark" wrote in message
...
Please post any comments, links, or suggestions for
reference sources on getting started with class modules.

thanks.

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" wrote in message
...
Please post any comments, links, or suggestions for
reference sources on getting started with class modules.

thanks.

Thanks, I'll look at it.
-----Original Message-----
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.

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.

--

"Bob Phillips" wrote in message ...
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)

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.

-----Original Message-----
Message unavailable

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

http://www.enhanceddatasystems.com/E...rogressBar.htm

Robin Hammond
www.enhanceddatasystems.com

"mark" wrote in message
...
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.

-----Original Message-----
Message unavailable

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

"onedaywhen" wrote in message
om...
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.

--

"Bob Phillips" wrote in message
...
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)