Explanation on VBA code: Not {variable} Is Nothing

[scott micklo]

Hi Experts. This is a very basic question and I am looking just to ensure I am understanding what it is doing in code:

Set searchresult = .Find(What:=lookingfor)

if Not searchresult Is Nothing then
msgbox "YES I FOUND IT"
else
msgbox "NOPE"
end if

if Not Searchresult is Nothing

Is this an error catching of sorts so that after doing the search (.find) if it finds what im looking ( RETURNS A TRUE ) then will execute the steps of finding it

if it does not find what I am searching for (RETURNS A FALSE) then will execute the else steps?

In english does If Not... Is Nothing = a double negative and means it has what Im looking for?


Thanks so much


PS -->>> what kind of error is generated if I do a .Find and it does not find what Im searching for (and I do not have this Not is Nothing)?

[AliGW]

Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

• Use concise, accurate thread titles.
  
• Your post title should describe your problem, not your anticipated solution.
  
• Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
• Responding to a request to change your thread title by doing so is mandatory.

To change a title go to your first post, click EDIT then Go Advanced and change your title.

No help to be offered, please, until the OP complies with this request.