


By default, it is hidden and needs to be enabled. There is a possibility you may not find the developer tab in the ribbon.Go to Developer Tab –> Insert –> ActiveX Controls –> Combo Box (ActiveX Control).In this first step, I will use a combo-box and configure it so that when you type in it, the text is also reflected in a cell in real time. Writing a short VBA Code to make it work.To follow along, download the example file from hereĬreating the searchable drop-down list in Excel would be a three-part process:

The intent is to create an excel drop down list with a search suggestion mechanism, such that it shows a drop down with the matching options as I type in the search bar. In this tutorial, you’ll learn how to create a searchable drop-down list in Excel – i.e., a drop-down list that will show the matching items as you type.īelow is a video of this tutorial (in case you prefer watching a video over reading the text).įor the purpose of this tutorial, I am using the data of Top 20 countries by GDP. One of its features is search suggestion, where Google acts smart and gives us a list of suggestions while we are typing. We all use Google as a part of our daily routine.
