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.Īll purchases help to support this blog - thanks! 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. (Open the workbook, ALT F11 to open the VBE and the code can be found in the relevant sheet object) Step 1: Create a List of Values and Name It Click here to Enrol on the Ultimate Excel VBA CourseĪll purchases help to support this blog - thanks!Ĭlick here to download the featured file.

How to add drop down menu in excel 2016