AutoComplete from Validation List

P

Poo Poo Jones

I need to add a column to a worksheet that shows the Country of Orgi
for a product and that county's assigned computer code (Ex. Unite
States - 10001). I have a list of counties and correspoding codes bu
the list to so long (300 countries) that I would like to be able t
type in "United" and have the cell auto complete the rest. Otherwise
have to scroll through a drop down menu of over 300 entries.

Any suggestions would be appreciated. Thanks
 
D

Dave Peterson

Debra Dalgleish shows a way to use two data|validation cells.

The first cell can show A through Z, then second cell can show the countries
that start with that first letter.

http://www.contextures.com/xlDataVal02.html

As an alternative, you may want to look at using a combobox from the control
toolbox toolbar (not from the Forms toolbar).
 
Top