I have a user form where the user will input a serial number.

There is an Add button and I would like that when the user clicks this button, the program searches a particular worksheet to check if that serial number already exists. If it does, then the user must be asked to enter new unique number.