How to create Singleton Pattern in VBA?

[Paul]

Hi,

I am a newbie in VBA. This is first time I try to use customer classes
in VBA. I want to know whether it is possible to create Singleton
Pattern in VBA?

For example, in java we can do this:

public class MyClass {
private static MyClass instance;
private MyClass() {}
public static MyClass getInstance() {
if (instance==null)
instance=new MyClass();
return instance;
}
}

Such that we can call: MyClass.getInstance() to retrieve the same
reference all the time.

Does anyone know how to do it in VBA?

Thanks a lot.

Paul

 

[NickHK]

Given that the only types of instancing on VBA classes is Private and
PublicNotCreatable, the WB containing the class could control its creation.
As I understand it, as each instance of the class gets its own local data,
such a concept as below does not exist natively in VBA.

NickHK