Hello all, How do I test if an object variable is set to Nothing in an If...Then statement?
C Conan Kelly Aug 7, 2006 #1 Hello all, How do I test if an object variable is set to Nothing in an If...Then statement?
B Bob Phillips Aug 7, 2006 #2 if obj Is N othing Then 'do something -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
if obj Is N othing Then 'do something -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
B Bob Phillips Aug 7, 2006 #3 Typo if obj Is Nothing Then 'do something -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
Typo if obj Is Nothing Then 'do something -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
C Conan Kelly Aug 7, 2006 #4 Bob, Thanks for your help, Conan Bob Phillips said: Typo if obj Is Nothing Then 'do something -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) Click to expand...
Bob, Thanks for your help, Conan Bob Phillips said: Typo if obj Is Nothing Then 'do something -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) Click to expand...
G Guest Aug 7, 2006 #5 I just did this today. Here's how I did it: If something Is Nothing Then ...do stuff... End If Sincerely, Pflugs
I just did this today. Here's how I did it: If something Is Nothing Then ...do stuff... End If Sincerely, Pflugs
C Conan Kelly Aug 7, 2006 #6 Pflugs, Thanks for the help, Conan Pflugs said: I just did this today. Here's how I did it: If something Is Nothing Then ...do stuff... End If Sincerely, Pflugs Click to expand...
Pflugs, Thanks for the help, Conan Pflugs said: I just did this today. Here's how I did it: If something Is Nothing Then ...do stuff... End If Sincerely, Pflugs Click to expand...