vba - Excel Drop Down + search function -

i have drop down lot of list in it. taking long time search / scrolling down through list.

is there way make easier? example: can extend scroll range longer (which 8 items only), or maybe sort of autocomplete typing item name.

its search item easier in drop down list. thanks!

you can use:

1. cascading dropdown (such xls cascading lookup based on pivot table style datasource? , http://www.contextures.com/xldataval02.html)
2. use formula in named range list validation simulate autocomplete
   1. create named range test kind of formula : =offset($a$2,match($c$1&"*",$a:$a,0)-2,0,count($a:$a))
   2. where:
      • your list of data in column (values should sorted alphabetically)
      • the current cell applying validation on c1
   3. then can:
      • start typing text want in cell a1, instance wash
      • then click on drop-down list
      • the dropdown list begin @ whashington , on

i've translated 1 of old workbook tell me if doesn't work.

[edit] quick test seem make work (you should restrain end of list beauty of formula)