View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Auto Complete a select from a data validation list

If you can use programming, there's a sample file here that provides a
combobox from which you can select one of the values from the data
validation list. In the combobox, you can enable autocomplete:

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

But with a list that long, it may help users to select from a category
first, then select an item from that category, using dependent lists:

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

Lele wrote:
I am using a list of 5,000 items stored on a separate worksheet in the same
work book for data validation of the items being selected on my order form.
The data validation feature seems to be working ok, when you select the
down-arrow, the list appears. However, with 5,000 potential selections,
scrolling to your choice is too time consuming. Can I make this list work
more like a combo box, so the user can time the first few letters, and the
list will search for matching items?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html