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 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.
We use the Combo box, which is a drop-down list element to gain more control over the input of our user.