Searchable Drop-Down List

[VinceF]

Greetings Experts,

After trying to make a searchable drop-down list without any sucess I created a Data Validation list and then used KuTools to make it a searchable drop-down list. To my dismay after protecting the sheet it doesn't work anymore. I reached out to their support and received the following explanation...

""For the current version of Kutools for Excel, the Searchable Drop-Down List feature will not be available after protecting the sheet.""

I'm hoping someone here has a work around for this.

Much appreciated...!
VinceF
Office 2016

 

[Akuini]

If you're willing to use an add-in, you can try a free Excel add-in called "Search deList" to get searchable data validation. You can find it here:

I created an Excel add-in called “Search deList”, to create searchable data validation

I created an add-in called “Search deList”, and I share it as a freeware. Its function is to speed up searching in data validation list. In any cell that has data validation (with List type) pressing ALT+RIGHT will open a Userform with a combobox. You can type multiple keywords (separated by a...

www.mrexcel.com

 

[VinceF]

Akuini,

Thank you for your reply and suggestion. I will give this a try and let you know.

VinceF