Forum Discussion
Using the Combo Box to search a data list
Good morning All, I am currently utilizing Data Validation in combination with Vlookup to (A) Search and autopopulate data within our spreadsheet (approximately 26,000 employees). We don't have th...
Try a free Excel add-in called “Search deList”.
It works like this:
In any cell that has data validation (with List type) pressing ALT+RIGHT will open a searchable combobox.
Type some keywords to search, separated by a space, e.g "ma la"
The list will be narrowed down as you type.
Hit ENTER to sent the value to active cell.
You don't need VBA or combobox in your workbook, so you can save your workbook as .xlsx.
You can find it here:
https://www.mrexcel.com/board/threads/i-created-an-excel-add-in-called-search-delist-to-create-searchable-data-validation.1189466/