Dear All,

I hope you are all well.

I have a Customer Database table with about 600 customers. That table is on a hidden sheet.

I have a sheet named "Home" wich I have a cell that you can look up for a customer by typing the Customer Number. on the cell below, I have a VLOOKUP formula that brings the customer name in case the same is on the database.
Below that cell, I have a CommandButton to add new entries/Customers.

I need a code, if possible, that if the user type (In the cell I mentioned above) a customer code that is not maintained in the Database or not existing, a Information Box will open informing that the customer does not exist in Database with the option (CommandButtons "Yes" and "No") to add a new entry. If the user type "Yes", the userform I have to add a new entry opens, if the user type "No", delete the code he typed and leaves the Cell blank.

What I have at the moment is using the "Data Validation", but I can only have a Information Box informing that the number typed is not existing, but no option to click a button and create a new entry.

Any ideas?

Your assistance on this matter will be highly appreciated.

Best regards,
Filipe Oliveira.