Duplicate VBA code not working!

Hi, I'm at the final hurdle of completing my userform and I need a check for duplicate entries.

The code I am using is not working! Regardless of what reference I wish to submit on the form it says it's a duplicate when it's not! Please help!

The duplicate check code is highlighted in bold red - have I placed it in the wrong part of the code or is it just wrong altogether??


When the form is filled out and user clicks OK I have a few of these so empty fields are not added.

Please Login or Register  to view this content.

Straight after that I have

Please Login or Register  to view this content.

Finally the OK button to add the entry to the sheet

Please Login or Register  to view this content.

I can post the full code too if that helps, but thought it was too long and repetitive of what I posted above. Thank you in advance!

Your match function will return an error if it doesn't find the textbox value in the list.

Originally Posted by rorya

Your match function will return an error if it doesn't find the textbox value in the list.

Hi Rory,

Thanks for the quick response. That makes sense why it's telling me any gibberish I enter is a duplicate.

What can I do to change it so that it only looks for what is already in the worksheet "Admin"? Also, is the placement fine for it to work after?

Apologies - I am learning most of this on the job, so I may be asking obvious questions

Add the word Not in front of IsError and the code should do what you want.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here. (Provide the link to you post, don't just mention that it's cross-posted. We'll never find it.)

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)