Hi Sandy. First off if you have a list of legitimate locations it is much better to present the user with that list. That way they select something. This avoids both possible spelling mistakes, and nknsense entries. What if someone entered "sgdhfuffb"? What would you do with that?

This could be done with a userform.

I assume you have some logical linkage between.possible location items and "addresses".