Forum Discussion
Solved
Searchable List Excel VBA or Formula
Hi, I would like to be assisted with a formula or VBA that could accomplish this task. I have attached the file with explanations. Thank you !
- Try a free Excel add-in called “Search deList”.
Please, check this discussion:
https://techcommunity.microsoft.com/t5/excel/searchable-dropdown-lists-on-multiple-rows/m-p/3647239/highlight/true#M166468
See the attached version. It is based on Data Validation Combo box Click
Since the workbook now contains VBA code, you'll have to allow macros when you open it.