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

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

"Paul" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>