Add List Box Or Combo Box To Worksheet. When you use a list box or combo box to enter selection criteria you might want to be able to specify all records. Click either the List Box tool or the Combo Box tool.
On the Design tab in the Controls group ensure that Use Control Wizards is selected. Combobox1list range cells 11cells 1001value combobox2list sheets 1range NamedRange arr array 123 combobox3list arr. The worksheet names are PLK MKO HYT etc.
The main purpose of using drop down lists in Excel is to limit the number of choices available for the user.
Add a combo box to a worksheet. The main purpose of using drop down lists in Excel is to limit the number of choices available for the user. You will see the symbol hold the left mouse pointer where you want to place it and drag it to the width and height you want. When you want to display a list of values that users can choose from add a list box to your worksheet.
