Dropdown with Searchable Text Without Hitting Enter

[c.clavin]

Hi guys, I recently watched a YouTube video where FILTER and SEARCH is used to pare down a search query for a dropdown list. It seems like just by typing letters the dropdown list was able to automatically update and the dropdown had only the returned results displaying. I don't know if there's something I'm doing wrong, but I need to hit Enter in order for the dropdown to update based on what I just typed in. I remember from ages ago there were different cell types where it worked with or without hitting keys, I completely forgot over the years. Can anybody help me with this? Video at the exact moment linked below. Thanks.

 

[Akuini]

@c.clavin
If you're interested in another method for searchable dropdown:
I created an add-in for searchable data validation (with combobox) , called "Search deList", and I'm sharing it as freeware.
Its function is to speed up the search in the data validation list. It works on multiple cells. In any cell that has data validation (with List type) 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. It's a "live search", you get search results while you type.
By using this add-in, you don't need VBA to have this searchable combobox, so you can save your files as .xlsx.
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

 

[c.clavin]

It appears it's a Mac thing. When I go on Windows 10/11, there is no need to hit enter/click out of the cell. That's strange, I thought both versions are based on the same code.