Hi,
In my application, I need a following construction:
Public Var as Object ' (at module level)
...
If <Var not set> Then Set Var = CreateObject("XXX")
But how to define the condition? For non-declared explicitly or declared as other type variables IsEmpty() shows True until the value is set, but somehow for the Object type variable it doesn't work, even though the variable itself is shown as "Nothing" in the debugger. (I also tried IsNull - it doesn't help either).
Thanks.
In my application, I need a following construction:
Public Var as Object ' (at module level)
...
If <Var not set> Then Set Var = CreateObject("XXX")
But how to define the condition? For non-declared explicitly or declared as other type variables IsEmpty() shows True until the value is set, but somehow for the Object type variable it doesn't work, even though the variable itself is shown as "Nothing" in the debugger. (I also tried IsNull - it doesn't help either).
Thanks.