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!
You don't need VBA.Why not just use a VLOOKUP formula?
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
that would work OK if I was the only one using it. I would like to send this file to multiple cities that ship our product. More for the end users to simply lookup a zip and know what route on the fly.Originally Posted by royUK
Having a macro would simplify the need for a VLOOKUP - if it were just me VLOOKUP would be great.
Last edited by kjwaller; 01-14-2009 at 12:06 PM. Reason: add attachment
I don't follow your logic at all. A data validation list to select zip codes from with a VLOOKUP formula to return the results. What could be simpler? Look at the VLOOKUP example here
http://www.excel-it.com/excel_functions.htm
VBA alternative would mean that all users would need to enable macros, this might not be allowed by some IT departments & would need explaining to many users.
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks