Stopping VBA Search from showing error if searched item does not exist

Hello, I have a piece of code that searches the M column for an entered number. However, the purpose of the search is to confirm that the number im searching doesn't exist. I mean, I have an excel file with thousands of numbers in the M column, so when given a new number for the column, I want to be sure there isn't a duplicate number in that column. Here is what I have so far:

Please Login or Register  to view this content.

How can I prevent it from showing the error message, and instead show a message box that says "Number does not exist" ?

Thank you for reading my question,

Johnny O

Something like this.

Please Login or Register  to view this content.

Hello Johhny O,

Welcome to the Forum!

By assigning a Range object variable to the Find result, you can then test if the value was found or not. The Find method will return either a reference to cell where the value was found or the special object value Nothing.

Please Login or Register  to view this content.