Can you do a search in a dropdown menu?

HI guys,

I have the following problem .... I have created a dropdown menu to select data from another table... but there will be a plenty of data, so I have to create somehow a search function in the dropdown menu. i.e. when a user types "box" in the dropdown menu will show up only the items beggining with letters box**** . Is it possible to do such a search in a dropdown menu in excel? Otherwise he had to scroll down all the records and find the one he needs manually

G'day mechant,

Try this,

http://www.contextures.com/excelfiles.html#DataVal

Then find these. Please find out which one is for you.

DV0043 - Data Validation Combobox With Entry Check

DV0032 - Dependent Data Validation Combobox

DV0028 - Data Validation Combobox Named Lists

DV0020 - Data Validation Combobox

and hopefully I did not overlook any other options in that list.

Here a link to a workbook that I apply an autocomplete to a data validation.

http://www.excelforum.com/1951983-post1.html

HTH

Here's A couple of examples
http://www.excelforum.com/attachment...cardfilter.zip
http://www.excelforum.com/attachment...ywildcards.xls

Located here
http://www.excelforum.com/excel-prog...y-results.html