Check for duplicate entry in a userform and fill in text boxes with duplicate information

Hi all,
I have created a userform in Excel 2010 for use as an inventory count entry form. After entering a tag number in txt1, txt2 - txt4 is automatically populatd. txt5 - txt6 are manual entries.
My problem is that a tag number should be entered only once. If the user enters the same number, I need to caution them that the number has already been entered and the entry needs to populate all text boxes with the information previously entered. If the quantity in txt5 then needs to be revised, the user is able to do so.

Avoid using worksheetfunctions if there's a valid VBA alternative.
I Rewrote your Add-button code since you didn't take into account that it could be a revised previously entered tag.
Play around with the form and let us know if it works as expected.

Thanks so much. I did play around a little and found the perfect match between your code and mine. Works like it should.
Thanks again

Thanks for the feedback and the rep