"If c is Nothing" v "If Not c is Nothing"

[LEXCERM]

Hi,

Need an answer to a simple question please. Both statements below work, but why is it that whenever I read topics on this, people always use "If NOT c is Nothing"? Is there an advantage of writing it this way?

Example A:

Set c = Cells.Find("Dave")
If Not c Is Nothing Then
MsgBox "found"
Else
MsgBox "not Found"
End If

Example B:

Set c = Cells.Find("Dave")
If c Is Nothing Then
MsgBox "not found"
Else
MsgBox "found"
End If

Thanks!

 

[shg]

These are functionally equivalent:

if myString <> "Bob" then
  msgbox "It's not Bob"
else
  msgbox "It's Bob"
endif

if myString = "Bob" then
  msgbox "It's Bob"
else
  msgbox "It's not Bob"
endif

Your example is the analog for objects, but there is no "<> Nothing" syntax for objects.

I tend to prefer B just to avoid the use of the additional operator, but the difference is minute, and would use A if I saw any advantage of clarity.

 

[LEXCERM]

Thank you for the clarification shg. Just wanted to see if I was missing something glaringly obvious. "If NOT" seems to be the preferred methond for the majority of people, but for simplicity example B seems easier to follow.

 

[shg]

You're welcome.