![]() Create the actual combo box by clicking and dragging to define the parameters of the control. ![]() The mouse pointer changes to a small crosshair. Click on the Combo Box tool in the toolbar.Make sure the Forms toolbar is displayed.(For this example, let's assume that you create the list in cells K7 through K13.) For instance, if you have a list of names you want to appear in the combo box, create that list of names in your worksheet. Somewhere in your worksheet, create a list that specifies what you want to appear in the combo box. ![]() To create a combo box, follow these steps: This control allows you to pick an option from a drop-down list, and then determine what was picked. Excel includes several different form controls that you can add to your worksheets.
0 Comments
Leave a Reply. |