Checking if an object variable is set

  • Thread starter David C. Holley
  • Start date
D

David C. Holley

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
 
Top