I have a form where the user enters their ID number,
When User inputs their number into Cell A5, i want it to check if the contents match a list that is on my Lists page.
If they are not set up, i want them to get a msgbox.
I am guessing this is in in the Worksheet.change section of the vba.
Whats the best way to do this.
When User inputs their number into Cell A5, i want it to check if the contents match a list that is on my Lists page.
If they are not set up, i want them to get a msgbox.
I am guessing this is in in the Worksheet.change section of the vba.
Whats the best way to do this.