Find duplicated value by comparing textbox and column

Hi

Pls refer to my uploaded example file.

I have a table where i want to make sure no duplicated values can be posted in the B column.
I have a userform that is used to add data to the table.

However, i can not prevent a value from being added since my current code is checking if there are
duplicated values in the column only.

I want to check if the value that I have typed in the textbox is to be found in the B column before the code
that creates the new row and saves the data to the table is being triggerd.

Here are my two codes

1. Add row to table from userform textboxes
2. Check for duplicates in the B column and print all found duplicated values in a msgbox

Please Login or Register  to view this content.

It does not work to have it in the exit part of the textbox.

I forgot to mention that i also use the same userform (in my real document, not example)
to view data, so the the duplicate code in exit of the textbox would not work since it would detect its own row.


it would be much better if i could get this code to work

Please Login or Register  to view this content.

but it keeps displaying the msgbox as duplicates even if there are none in the column

forgot to mention that i have declared the "newdupdetected at the top of the module as "public newdupdetected as integer"