I have a master list of over 1000 zip codes (5 digits max length) and delivery routes assigned to each zip code.

I like to build a macro where you type in the zip code in a text box and click search.

When it searches, i'd like it to bounce off the master list of 1000 zips and return the delivery territory.

For example,

If you type in 96634 - it would return CALIFORNIA

I have very little VBA experience and dont know where to start. Thanks to everyone who can help!