VBA Help - If no number in range, then display error.

Hi guys,
I'm working on some coding where I can search for a customer order via a UserForm and then it will attach it to Outlook and get ready to send an email, I've managed to program it so that if text or NO number is entered it will prompt the user for a number. However, when I enter an incorrect order ID (like one that doesn't exist) it will attach ALL of the sheet (with all customer data on it).

I was wondering if it is possible to display an error and say "Enter a valid order number" if the order reference does not exist.

Any thoughts?

My code is below:

Please Login or Register  to view this content.