VB6.0
Excel 2002, SP3

How can I get private and public instancing class modules to communicate
with each other?

Example

I am creating a program that using a class name of "TempEmployee" (Need
multiple instances of this class, thus private instance is the only instance
available) and a collection class name of "TempEmployees" (This object, only
need one instance of it and I would like to be able to reference to it from
within any other module within the project, but when I attempt to set a
public variable to it, it comes back stated can't do it as a public variable
can't contain a private class module). I also get the same basic issue with
I attempt to combine public and private classes into each other. What is
the best way to resolve this issue so as I don't have to do so much coding
and work arounds?

One way, I could create properties in so many other objects as a reference
to this one object, on the other hand, that in itself seems to be a lot of
work and could lead to possible overlooking. What is a good book on this
sort of VBA Class module coding?

--
Thanks,

Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000