View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jean-Pierre Bidon Jean-Pierre Bidon is offline
external usenet poster
 
Posts: 30
Default How to test if an object exist really

Hie,
I try (unsuccesfully to test if an object of my own is "Nothing" or not
I created an object class, let's call it MyClass.
Thren I declared an instance of this variable like this:

Dim MyObj as new MyClass
Dim boTest as boolean

Set MyObj = Nothing
boTest = MyObj Is Nothing

Strangely, boTest is false! (I hoped this test retrun was true)
The question is : where did I make a mistake.
Thanks for your help.

--
Jean-Pierre Bidon
Interstat
91 rue de Rennes
75006 Paris
Tél: 01 45 49 19 17