Class Newbie question #2 - Check if Class already loaded/set?

I am creating my first class and it will be possible for the Class Initialize event to fire twice.

Is there any way to check if the Class is already "loaded" (I'm not sure I'm using the right terminology here)?

Is it possible to "unload" the class after its usage to avoid "double loading"?

Set "ClassName" = Nothing


Or, declare a public variable (e.g. KKK) that when the class is initialized first time, you give kkk a value (e.g. 999). then, before trying to re-initialize it, check the value of kkk: if it is 999, do not initialize, else, initialize.
Does it make sense?

Originally Posted by adyteo

Is it possible to "unload" the class after its usage to avoid "double loading"?

Set "ClassName" = Nothing

Unfortunately no. I need to avoid ending the class at that point.

Originally Posted by adyteo

Or, declare a public variable (e.g. KKK) that when the class is initialized first time, you give kkk a value (e.g. 999). then, before trying to re-initialize it, check the value of kkk: if it is 999, do not initialize, else, initialize.
Does it make sense?

Yes it does make sense. I'd prefer to avoid adding global variables. Guess it can't be helped.

Thanks for your help +1

thanks for the +

if you find a method to check whether the class has already been initialized, post it here. we all learn something new every day

Originally Posted by TKCZBW

As a class must be 'loaded' into an object (as far as I understand, although happy to be corrected), could you use:

Please Login or Register  to view this content.

It sounded good and I thought it would work. "Compile error: Invalid use of object"

P.S. you are right that a class is an object. I didn't know but I checked. VarType(classname) = 9 (9 = vbObject)

What did you actually try as code - I assume you didn't use Object as a variable.

A class is not an object - an instance of a class is. Typically you would store this in a variable which you can indeed test to see if it's Nothing.

Originally Posted by romperstomper

What did you actually try as code - I assume you didn't use Object as a variable.

A class is not an object - an instance of a class is. Typically you would store this in a variable which you can indeed test to see if it's Nothing.

Hi Rory, Class is unknown territory to me.

Below is what I tried.

Please Login or Register  to view this content.

You need Is Nothing, not = Nothing.

Originally Posted by romperstomper

You need Is Nothing, not = Nothing.

Of course! What was I thinking?!?

Thanks Rory

Originally Posted by mc84excel

What was I thinking?

I've yet to figure that out.