Move your cursor to the worksheet area and click anywhere.Click here to know how to get the developer tab in the ribbon in Excel. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |