VBA Code to find duplicate in worksheet

Hi all,

I was wondering if anyone could help me with a problem I have come across. I need a code that when I make a selection on a combobox on a userform it will check it against a a list in column A of a worksheet and a msg box will pop up to say it matches or is a duplicate.

Any help would be massively appreciated.

Thanks in advance!

Hi,

I haven't actually created the spreadsheet yet, but I can draft one up yet. I have rough one, I'll clean up.

Sorry... I'm being stupid. How do you add a spreadsheet?

Worked it out, but won't let me load the file. Very annoyin.

Hi,

I've created a code but can get it to work. Reg1 is combobox and Reg130 is a label on which I want my results to appear. I've putting the code into Reg1, I think this is the right way round...

Please Login or Register  to view this content.