In working in a project at work. I have a attached my workbook for easier understanding. To make thinks short, the combination of Columns A and D are the unique identifiers or primary Keys. A Roll Number (Col A) and Receiving Ticket (Col D) cannot have duplicates. When the Users Clicks the Check Button I want a piece of code that Checks the Information input in the Roll and Ticket textbox and if the combination already exist i want a message box to appear with an error advising the user that the combination of the two already exist. Thanks you very much for taking the time to read this. have a nice day!