Object class in Excel VBA

  • Thread starter Thread starter Tom Chau
  • Start date Start date
T

Tom Chau

Dear all,

I hope to ask 2 questions on the Class Modules in Excel VBA.

1) It seems that only 2 instancing property are available for Excel
VBA: Private and PublicNotCreateable.

May I ask whether there will be some ways to declare the class module
as MultiUse or SingleUse?

2) Is there any method to use the classname string to initialize the
object. For example, we could do that by $className->new() in PERL.

Currently I use a switch clause to dispatch the constructor for such
PublicNoCreateable class but it need to modifiy each time a new class
is added.


Tom
 
If you want more flexibility in class modules for Excel, you could mak
a DLL in another language such as VB6
 
Back
Top