You can see I made the drop down list in the D5 cell, that’s why the target address is D5.

Here, I have declared two strings called old_val and new_val.

If Target.SpecialCells(xlCellTypeAllValidation) Is Nothing ThenĮlse: If Target.Value = '' Then GoTo Exitsub Else Private Sub Worksheet_Change(ByVal Target As Range)

Now, you will see a Private Sub will be created.

Afterward, select the marked drop-down button.

Next, right– click on the sheet where you want to select multiple options.

Consequently, the Visual Basic Editor will appear.

In the beginning, go to the Developer tab.

Now, I will show you how you can write a VBA code to make multiple selections from a drop down list in Excel. Step-02: Write VBA Code for Multiple Selection

Here, you will see that the item you selected has replaced the previously selected item.

Next, select another item from the drop down list.

After that, you will see that the selected item is showing in the selected cell.

Finally, you will see that a drop down option is added to your selected cell.

Next, click on the marked button to add the selected range as Source.

Next, click on the marked button to select the source.

Then, click on the drop down option for Allow.

Next, the Data Validation dialog box will appear.

Secondly, select the cell where you want to add the drop down list.

Firstly, create a section in the Excel sheet for adding the drop-down option.

In this step, I will create the drop down list for the dataset. So, you will have to write a VBA code for multiple selections. But, a conventional drop down list always selects a single item. For this, you will have to create the drop down list first. In this example, I will explain how you can create a drop down list for multiple selections and select duplicate items.

Make Multiple Selection from Drop Down List with Duplicate Options In a practical scenario, you may encounter a much larger and more complex dataset.ġ.

Note that it is a simple dataset to keep things straightforward. Here I have several stationery elements, using these I will create a drop down list in Excel and make multiple selection from there. Selecting Multiple Options from Drop Down.xlsmģ Ideal Examples of Multiple Selection from Drop Down List in Excelīefore diving into the session, let’s get to know about the dataset that is the base of the examples.

Vlookup with drop down mac excel 2013