To be or not to be - is a Object set or not?

[hgrafen]

Hi experts out there,

we need to test wether an object is set or is <nothing>. How can we do this?

greets
Hansjoerg.

 

[LittleSmudge]

If objectName Is Nothing Then

It's that IS word that catch so many people out.


G.

G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[PHV]

something like this ?
If Not myObject Is Nothing Then
MsgBox "OK, myObject is set"
Else
MsgBox "myObject Is Nothing"
End If

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[hgrafen]

Thank's!

It works.

Hansjoerg.