Collection of Class Modules

Hi all.

I am trying to create a collection of class modules. (Originally, I wanted to have a collection of user defined types. But after hours of head banging realized VBA doesn't let you do that)

I think that the problem I am having has to do with the fact that the class i want to add to the collection has two class module's in it. [ See Below ]

Please Login or Register  to view this content.

Note: cAlpha and cBeta are each Class Modules that I created.


One question, do I need to call New on cAlpha and cBeta members?

Please Login or Register  to view this content.

Because right now I do:

Please Login or Register  to view this content.

Now, I would LIKE to do the following:

Please Login or Register  to view this content.

The error is as follows:

Run-time error '91':

Object variable or With block variable not set


BUT WHERE?


Thanks to anyone that can help!

This is how I go about doing collections of classes.

CAlpha

Please Login or Register  to view this content.

CBeta

Please Login or Register  to view this content.

CMaster

Please Login or Register  to view this content.

CMasters

Please Login or Register  to view this content.

Test module to demostrate uses

Please Login or Register  to view this content.