There are a few tweaks to the code that you make and I go through these in the video.

Close the VBE and you should find that you can select multiple items in your drop-down list.

In the Code window (that’s the big white area to the right of the Project Explorer), paste the code included in the downloadable workbook (see form above to download the workbook).

In the Project Explorer select the worksheet that contains your drop-down list.

If you can’t see it, use the keyboard shortcut CTRL R to open it.

Make sure the Project Explorer is visible – it displays all the workbook’s worksheet names.

Use the keyboard shortcut ALT F11 to open the Visual Basic Editor (VBE).

To add the VBA (visual basic for applications) code to your drop-down list follow these steps:

Select the name you gave your list in Step 1īy default a drop-down list will only allow you to select one item.Ĭlick here to receive FREE EXCEL TEMPLATES from Simple Sheets STEP3: Add the VBA Code to Your Drop-Down List.

Press F3 on your keyboard to open the Paste Name dialog.

In the Data Validation dialog, in the Allow: list select List.

Click on the Data Validation button in the Data Tools group.

Click on the Data tab on Excel’s ribbon.

Select the cell or cells you want the drop-down list to appear in.

I did this on a separate worksheet to the list created above in step 1, although it could be created on the same worksheet. The next step is to create the drop-down list. Step 2: Create the Drop-down List Using Data Validation

Press the Enter key on your keyboard to confirm.

Type a name that starts with a letter and does not contain spaces.Click in the Name Box (just to the left of the formula bar – it displays the cell address of the active cell by default).

In the video I create a list of values that I wanted to appear in the drop-down list on a separate worksheet. Click here to receive FREE EXCEL TEMPLATES from Simple Sheets Step 1: Create a List of Values and Name It

Drop down menu in excel 2016