If Found then Display error

  • Hello,

    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!

  • Re: If Found then Display error


    Thanks for taking the time to share you knowledge with "the noobs". Works perfectly, have a nice day and thanks again!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!