Message Prompt: A UserForm TextBox value is found in a column range.

[poizones]

I have a userform which includes textboxes. All I need is that when a user entered any name or numbers and found out that they exist in the column range, a message will popout that says "The user or number already exist. Please check your entry."

If it's not a duplicate, the data will be recorded in a specific column(B:B) but at the top of the existing data in a column(B:B) when clicking on the commandbutton.

Thank you all for the usual help.

[bakerman2]

Check out Application.Match.