how to create drop down menu in excel 2016

Simultaneously, a Code window will open.Also, double– click on the sheet where you want the task to be done. First, press ALT + F11 to open the VBA window.In this section, I will show the way to create a drop-down list with multiple selections which will take a repetition of data. Case 1: VBA Code for Multiple Selections with Repetition One will accept the repetition of data and another one won’t take the repetition of data. I will use 2 VBA codes to enable the list to accept multiple selections.

Now, it’s time to prepare the drop-down list for multiple selections. We have created the drop-down list already. STEP 2: Enabling Drop-Down List to Accept Multiple Selection by VBA Code

Create Drop Down List in Multiple Columns in Excel (3 Ways).

How to Create Dependent Drop Down List in Excel.

Make Multiple Selection from Drop Down List in Excel (3 Ways).

How to Make a Drop Down List in Excel (Independent and Dependent).

Finally, we will see a drop-down list created in Cell D5.

Alternatively, you can click on the small upward arrow in the Source section and select the data range from the worksheet.

Then, from the Data Validation window, select List in Allow section and write the range cells whose data you want to add to the list in the Source field.

Next, go to the Data tab and select Data Validation from the ribbon.

First, select the cell where you want to create the drop-down list.STEP 1: Create Drop-Down List by Using Data Validationįor creating a drop-down list with multiple selections, we have to create a drop-down list first. I will show step-by-step procedures in the below section. Our objective today is to create a drop-down list based on this dataset that takes multiple selections.

Here, we’ve got a dataset having a column Book Name which contains some book names. Step-by-Step Procedures to Create Drop Down List in Excel with Multiple Selections Create Drop Down List with Multiple Selection.xlsm

How to create drop down menu in excel 2016