Debug Error when trying Search values that are non-existing in the Database

[aeolusquiniquini]

So I have this View/Edit function on my sheet and it works fine when searching for values that exists. However, I dont know how to formulate the script for searching a non-existing value in the database. It gives me a Debug Error.

I am really not an excel wizard and been following some youtube tutorials only to finally come up with this. Some came from this forums also.

Hopefully, I can get some more assistance on this to get fully functional.

[CK76]

In general. You'd want to have Error Handling in code.

Ex:

Please Login or Register  to view this content.

Edit: You can read more comprehensive article written by Chip Pearson on the subject.
http://www.cpearson.com/Excel/ErrorHandling.htm

[nankw83]

You can amend your code a little to check if that search # exists or not

Please Login or Register  to view this content.

[aeolusquiniquini]

This is perfect Sir. A lot of thanks you. I do promise to better have a clear understanding of formulas specially trying to create them. Thats where my weakness is. I am really a newbie in this.

More power to you sir. And please do stay safe.

Cheers.

[nankw83]

Glad to help & thanks for the reps

[aeolusquiniquini]

You totally deserve it sir. I am currently working on a vlookup function on the same sheet. But before even asking, I will try to discover it myself first. :-)

[aeolusquiniquini]

Hi Sir,

Just a follow up on this. I have been also trying to have the mouse wheel work not sure what to do.

Maybe you can help on it too?

Thanks

[nankw83]

If you mean mouse scroll in the UserForm, I don't know how to do that I did a quick search & it doesn't seems easy either. I found some people referring to this LINK which they say it works, if interested.

[aeolusquiniquini]

Hehehe. its ok sir. I saw some few links too but I do not understand how to implement it or even where to put it. LOL