Check if Users ID is in List on Sheet

[tucker61]

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.

 

[arnelgp]

what you need is Data Validation.

 

[tucker61]

Never thought of that. Looks like I was trying to over complicate things. Thanks

 

[arnelgp]

there are many samples on the web. i am sure there are more easier tutorial. goodluck.