Userform VBA to check 2 columns (A & B) for duplicate entries

Hi Folks

This is my first post so please excuse the simplicity of the request

I have a userform that I use for data entry with lots of combo boxes, list boxes and text boxes

One thing i haven't cracked yet is to check for duplicates against two matching fields

Let me explain

If a user (for example) enters 'SAB' (which will be stored in column A) and then 'UK' (which will be stored in column B) and there is already an exact match for both, then I need to inform the user that a matching record already exists

The following is OK: (the dots below are meant to illustrate spaces between the columns!!)
Col(A).....Col(B)
SAB........UK
SAB........USA
SAB........Italy

BUT, if a user then tries to enter:

Col(A).....Col(B)
SAB........UK

I need my userform to register a duplicate entry.

My sub routine is detailed below

Many thanks for any help,

Steve

Please Login or Register  to view this content.

Hi,

I wasn't 100% sure from your code which variables where which but you could do something like:

Please Login or Register  to view this content.

to check if search_a and search_b exist on the same row, you need to assign the user entry fields to search_a and search_b and then the evaluate function will return true if it is a duplicate.

Thanks for your reply ragulduy - appreciate it

However, I need to substitute the text entries for actual variables. I have modified your code to do the following

Please Login or Register  to view this content.

The problem now is that I end up with a 'Run-time error '13' - Type mismatch

I can see that my variables are being correctly substituted with the text field entries but I get the error

Any ideas?

Thanks, Steve

Sorry, you need to add quotation marks to either sides of what you are searching, so:

Please Login or Register  to view this content.