Checking if an object variable is set

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David C. Holley - 04 Sep 2005 05:07 GMT

Is there a way to test if an object variable is set? I have a SET
statement in an For Each loop and would like to check if the object
variable is SET

For Each node In tvTargetControl.Nodes
If node.Key = "06ACT:PrintPurchaseOrder" Then
Set targetNode = node
Debug.Print "nodes exist"
Else
Debug.Print node.Key
End If
Next

Reply to this Message

Alex Dybenko - 04 Sep 2005 07:00 GMT

Hi,
you can use:

If targetNode Is Nothing then
'not set
else
'set
end if

Signature

Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

> Is there a way to test if an object variable is set? I have a SET
> statement in an For Each loop and would like to check if the object
[quoted text clipped - 8 lines]
> End If
> Next

Reply to this Message

David C. Holley - 04 Sep 2005 15:02 GMT

Should have none I was trying IsNothing() duh

> Hi,
> you can use:
[quoted text clipped - 4 lines]
> 'set
> end if

Reply to this Message