Hello Steve. The file you had created and attachedas I see it works as a single use or share workbook in terms of providing user access to a combo box listing all the required locations.

However in both cases the user as I see the file will have to scroll to the required location to make a selection, autocomplete is not available, and I could not use a leter key to navigate to the first location begining with that letter.

So may be I am missing something by way of know how on this one, but I can not see how to move ahead. I have read adn tried the procedure at http://www.contextures.com/xlDataVal10.html with the same result as the file you had attached.

Hippy