Thread: Class Modules
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Class Modules

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)