How to tell if object variable is set

[Amy Blankenship]

I have a global object variable that may or may not have already been set.
How do I tell if the variable is a valid reference to an object?

IsNull is false
IsEmpty is false
IsMissing is false
= nothing gives an error
IsObject is true

Not sure what else to try...

Thanks;

Amy

 

[Douglas J. Steele]

Close! <g>

If MyObject Is Nothing Then
' Object isn't set
End If

 

[Amy Blankenship]

Thanks! That helped a bunch.

-Amy

Close! <g>

If MyObject Is Nothing Then
' Object isn't set
End If