Check duplicate from userform values before pasting to worksheet VBA

Hello,
I'm trying to record data by using a userform which will then write/paste values of boxes in the userform to a Sales worksheet. Instead of writing/pasting directly values on the userform, I would like first once the userform 'Record' button is clicked to check whether 2 values (Supplier and Reporting Month) of the userform are not already recorded on the worksheet. If these 2 values exist already simultaneously, then a "Duplicate" message box pops. Then Exit the Sub and clear all the contents of the userform. Otherwise, it will write the userform values to a new line (row) on the Sales worksheet.

There were many ways of achieving the intended result nut I wonder if there is something simple and easy. I was thinking about using a evaluate command to use with Match function to render the formula on the worksheet Cell B15:

Formula:

Please Login or Register  to view this content.

Below is the workbook I wrote with some help to achieve it. The issue though is that it doesn't do what it is intended to do.

Your help is very much appreciated. Thank you.

@ebademci

This is an old thread and you are required to post your question in a new thread

I could not find any solution for my problem. Can you help me where I can find ?

ıt didnt work in my userform because of barcode digits. my barcode has 30 digit.
do u have another solution?

How are your 30 digit barcodes formatted as text??

Sorry. My barcode format is like "343009890000188999009". 21 digit.

If I enter that as a number in worksheet I get 2.4E+20 (excel converted it)
So are they stored as text or some other format

This works for me here with any length of text formatted numbers

Please Login or Register  to view this content.

Did you try this code in my excel files?
I tried but it didnt work.

can you add your codes and attach my excelfile here?