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