In this video tutorial, learn how to create a dynamic Google-type search suggestion drop-down list in Excel.
This technique shows you how to create a searchable drop down list in excel by using a mix of Excel Formulas and VBA. You will learn how to create dynamic search bar where it will show a list of all the matching records as you type.
The idea here to have a searchable drop-down list where you type a few characters of a text string and it shows you all the matching values.
This is inspired by the Google auto-suggest feature that shows relevant search results and also helps save time.
As soon as you type a few characters in the search box (which is a combo box), the search box shows you all the matching results. You can then select any of the results and that will be populated in the search box.
This technique uses a VBA code in the back-end, so you need to make sure your Excel file is saved as a macro-enabled file.
Also, this is a way to create a searchable drop-down list in Excel, but it sometimes tends to act funny. Also, it’s best to use it when you have less number of records only. With a high number of records, it can slow down, or even worse, hang.
Here is a written step-by-step tutorial and Download File:
Free Excel Course –
Paid Online Training –
Best Excel Books:
⚙️ Gear I Recommend:
Camera –
Screen Recorder – techsmith.z6rjha.net/26D9Q
USB Mic –
Wireless Mic:
Lighting –
Subscribe to get awesome Excel Tips every week:
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
somehow when i type a name in the command box, i do not get the flashing cursor, nor do I get to see the drop down menu as a I type. I redid it already 3 times?
how to I remove this? the drop down keeps on showing anywhere in the excel screen
i followed your tutorial video but it makes my excel file run slower.
I don't know if you're still monitoring this, but I tried this and its working pretty well until i get about 12 – 16 minutes in where I'm creating the name range. My array is pretty large and perhaps the reason why I'm getting "You can't use more than 8192 characters in a Microsoft Excel Formula". Any clue how I overcome this issue?
Hi. Thanks for the video. Just a question: The combo box activates everytime data is entered in another cell and hit enter, tab, delete, space and backspace keys on the keyboard. Would you have a solution for it? Thank you
Super thankful for the tutorial. My excel keeps crashing though after adding it :/ Any advice on how to solve it? I also added different dropdowns to different tabs (mapped to different lists ) and sometimes when I change to a different tab, I still see the dropdowns from other tabs, as if they were pending a selection. The lists are not interconnected between tabs though. Is anyone experiencing similar issues? Thank you all!
well how if we were to create another sheet copy paste countries list and put the countries n head to formulas and state the data range in which i select all the countires n saved the data fomula for example would be list 1, and then i head back to original sheet and create devoloper tab in combo box in which i have instert linked cell whereby i can choose any cell i want for reflection, i would state list1 and then exit developer tab, I would still able to get google kind of search but faster n yes it is depended on the changes on the second sheet n i would have to stick with second sheet but it would be faster approach
You are a good tutor / teacher sir. Clarity is your forte. regards
Can we do this in Userform combobox ?
How to apply multiple filters?
Wonderfully explained
Thank you bro ☺️❤️
How to create a Dynamic Search Suggestion Drop Down List in Excel in VBA
this isn't autocompleting though..
If you just feed your named formula into the range area on the combo box you don't need the macro.
Bullshit only works for one cell not for others
Can I create same for multiple rows?
Very useful!
Excellent Video! Thanks for your help!
Brilliant!
How to filter data of column 'E' while type name in search box.
Does anyone know if this is possible om Mac? I'm getting stuck, when I try to create the combobox, since I don't get the options 🙁
Works very slow with ~200+ records. Nonetheless I like the idea and executing.
Thanks ! Trump Excel
However, when I click suggestion by down arrow key then a popup says Microsoft Excel has stopped working.
How to give cell reference F3:F3 via shortcut key? 7:00
How to use this code in user form vba any body know please help
Excellent innovation..this really feels handy to use it in the sheets with large data sets..Thank u so much..keep shining..🎇🎇👏👏🤝🤝
am working with CELL("address") function within INDIRECT to allow multiple cells as a searchable drop downlinst, and all is working fine, Problem is, CELL("address") function use whole Workbook cells, (where ever I type no matter which Sheet I am working. I want to use specific sheet cell addresses, so when ever I work on other sheets this list should not update every time. Plz help
I came across this video then looking over your site I am very impressed. Many unique approaches to several issues that I had not seen before. Great work!
Hi Sumit.. love this technique. Putting it to use right away. Thanks for sharing. Thumbs up!!
Thanks that helped me a lot 👍
ok perfect now can you write this in VBA code ?
thanks
Thank you for the vedio. It really helped.
I have successfully implemented it into my worksheet. But as I use the down arrow key in the keyboard to select from the drop down list, excel stops working. Does anyone else is encountering the same problem. Does it have a solution or the value from the list can only be selected by cursor.
Thanks this is very helpful !
hi sumit, thats amazing, the excel sheet is going closed after running the vba. any solution!
Quick questions,
1. How can I create searchable drop down list for multiple cells?
2. If I add more countries into the county list, do I have to recode the whole list again?
Thank you
Thanks … Thanks