Userform - complex idea

Originally Posted by jsneak

**Update i got it working, thank you so much for helping me mate!

 If Me.textboxReplacement = textboxReplacement.Value Then

That test will always be TRUE! It compares the contents of the textbox to itself, so it will always match.

I took another look and fixed the compilation problem, which was a missing End If. I apologize, I must have made a change after my test and forgot to re-test.

I made the first textbox into a label, because the user will never enter data in that field.

I also dealt with the duplicate issue. The duplicate textbox is now also a label also because the user won't write in it. If there are no duplicates found, there is a message to that effect.

I changed your Initialize sub to an Activate, so that it blanks out all the fields every time it comes up.

Let me know if we're getting closer!!