UserForm not finding multiple entries

[manny88]

I was looking for a code that will help me look for multiple/dupes in a worksheet when entering information from a userform.

I struggled with this and searched google high and low and used the code:

If IsError (Application.Match (Me.NameTextBox, Worksheets("Admin").Columns(3),0)) Then
MsgBox "Entry already exists.", vbCritical
Exit Sub
End If

A bad copy and paste job, perhaps. Instead of telling me only that entry already exists in the sheet, it is telling anything and everything I enter already exists in the sheet, which is wrong.

I fear the issue is either the IsError or the Match telling it to showing everything as a duplicate. Please help in amended/improving this code!

 

[dmt32]

try including the Not operator & see if your code will now do what you want

If Not IsError(Application.Match(Me.NameTextBox, Worksheets("Admin").Columns(3), 0)) Then
MsgBox "Entry already exists.", vbCritical
Exit Sub
End If

Dave

 

[Fluff]

Cross posted Duplicate VBA code not working!

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[dmt32]

Cross posted Duplicate VBA code not working!

that will teach me not to check first! Thanks @Fluff

 

[manny88]

that will teach me not to check first! Thanks @Fluff

Hi Fluff, Dave,

I have never double posted like that before. I'm up against it with this one, so my sincerest apologies have noted! I will make a note of it on the other post too

Dave - thanks for the reply. I did try adding NOT, and tried it again just, but that doesn't find the duplicate entry and instead adds it to the sheet as if it were a unique reference

 

[Fluff]

What sort of values do you have in column C of Admin?

 

[manny88]

What sort of values do you have in column C of Admin?

It's a textbox.value in a userform where an individual may enter any text or number and add it to the spreadsheet.

 

[Fluff]

If Column C has a mix of text & numbers, then you will have problems. A textbox contains text, so if you enter 123 it will not find the number 123 in that column.
The easiest way would be to convert col C to text.

 

[manny88]

If Column C has a mix of text & numbers, then you will have problems. A textbox contains text, so if you enter 123 it will not find the number 123 in that column.
The easiest way would be to convert col C to text.

I can't do that as the reference entered are always prefixed with letters followed by numbers and on some occasions include a "/" within the reference. I wanted to code to find the exact match if and tell the user it is a duplicate.

 

[Fluff]

Please supply links to ALL other sites where you have asked this question.