Forum Discussion
A_SIRAT
Jan 22, 2023Iron Contributor
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
- CangkirBrass ContributorTry 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.