naxdual.blogg.se

In the Name Manager dialog box, we will select New and name the range camping sales with no space between words.We will go to the Formulas Tab, then Defined Names and select Name Managerįigure 11 – Creating combo box based on a named range We will now be able to click on the down arrow in the combobox to see our list.įigure 10 – How to add combo box How to create an ActiveX Control Combo boxĪn ActiveX Control Combo box is more flexible because we can make changes to its font, size, and colors.We will enter the range of our cells, change the drop lines to 8 and select OK In the Format Object dialog box, we will go to the Control tab.Next, we will right-click on the new combo box element and select Format Control.Once we click on the Combo box, we can now drag our mouse and draw the combo box in our worksheet.Next, we will select Form Controls and click on Combo box.We will go to the Developer tab and click the arrow under Insert in the Controls group.We will go back to the columns under Customize ribbons and mark the checkbox for Developer.įigure 4 – How to use combo box How to Create a Form Control Combo box.Next, we will click on Developer to highlight and lastly tap the Add button. If we can’t find the Developer in that column, we will go to Choose Commands from and select All Tabs.In the column on the right, we will mark the checkbox for the Developer.In the Excel Options dialog box, we will click on Customize Ribbon.We will go to the File tab and select Options.If we cannot find the Developer tab in the ribbon at the top of our spreadsheet, here is what we will do. One of these options is called ActiveX Control while the other is Form Control.įigure 1 – How to use combobox Setting Up a Workbook to Create Combobox In this article, we will explore two easy ways to create a combobox in excel. We use the Combo box, which is a drop-down list element to gain more control over the input of our user.