Forum Discussion
Auto complete text in a drop down list cell
In case anyone needs it, I just shared a new version of "Search deList" add-in, i.e Search_deList_v2.1.
Its function is to speed up the search in the data validation list. In any cell that has data validation (with type List) pressing ALT+RIGHT will open a User Form with a combobox. You can type multiple keywords (separated by a space) in the combobox to search items on the list.
By using this add-in, you don't need VBA to have this searchable combobox, so you can save your files as .xlsx.
This new version has some additional features, some of them:
- Several ways to search, like using AND or OR or LIKE operator , with or without keyword order.
- Sort the list by original order or ascending order.
- Widen or shorten the combobox width at run time.
- Insert multiple entries into the cell.
You can find it here (please check post #81):
https://www.mrexcel.com/board/threads/i-created-an-excel-add-in-called-search-delist-to-create-searchable-data-validation.1189466/post-5978517