Object class in Excel VBA

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
 
R

raypayette

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Naming class modules in Excel 2002 2
Can I create in VBA a class with instancing type different from 1 and 2? 2
Can you instantiate classes without hard-coding class names?? 2
Excel 2007 in Mac or Excel 2008 for Mac? 1
Private vs Public Class Modules 11
"Static" Methods in Class Modules 1
Excel VBA - counting cells by colors and names to it in two different rows. 0
Custom Object Structure 8

Top