I wonder if I could do something like make the classes variables private,
then make a public method in a module called "New[Name of Class]" that
creates the class...hmm...

"Jim Thomlinson" wrote:

There is class initailize which is as close as you will get to a consturctor.
Chip Pearson has a good discussion on instantiating classes...

http://www.cpearson.com/excel/ClassModules.htm
--
HTH...

Jim Thomlinson


"Gary F" wrote:

Every so often I want to create a class in VBA, but VBA doesn't seem to have
the concept of a constructor for the class - so you have to (1) call NEW, (2)
makes sure that the caller sets up the object right.

I'm sure there's an approach for simulating the above (a pattern). Can
someone share it?

Thanks!