M
mark
Please post any comments, links, or suggestions for
reference sources on getting started with class modules.
thanks.
reference sources on getting started with class modules.
thanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
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
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
B
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)
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)
M
mark
Thanks, I'll look at it.
O
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.
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.
M
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.
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.
R
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
http://www.enhanceddatasystems.com/ED/Pages/ExcelProgressBar.htm
Robin Hammond
www.enhanceddatasystems.com
B
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
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