This post will walk us through setting up a multiple item drop down selection list in an Excel spreadsheet using a bit of VB code from a vlogger who shared just such a bit of code (Bansal, 2025). This is Part 2 of this process (see Part 1 here).
Oh - and if we are new to the Developer tab in Excel, we can see how to get that working here, before we get onto the next element (Microsoft Support, 2024).
On the Developer Tab, to create my first dropdown list, first I created the drop down list that I wanted to use in an additional spreadsheet, with some additional details for when it needed updating. I intended to to hide this sheet on a "Competency_List" tab so that spreadsheet users would not see it (as users do not need to see it: they only needed to see, in the relevant cell, the list of options that they were going to select).
We select the first cell that we want our multiple selection box to appear in, and then go to the Data tab in Excel, then click on the "Data Validation" box in the Data Tools area. A dialogue box pops up. In the Settings tab we select "List", then in the source area select the range of our drop down from our - not yet hidden - "Competency_List" tab. At this stage, because this is "native" Excel ddl, we can only select one option (Bansal, 2025, 2:10).
Now we need to download and install some VBA code (which can be downloaded as a text file from here; Bansal, 2025). Open the text file and copy the code. Now back to Excel and click on the Developer tab, then the Visual Basic icon which will open the visual basic editor (or key Alt & F11). We double click on the sheet in the left-hand outline pane that we want the dropdown to appear in, then paste the copied code into the right-hand pane.
Our next step is to go through the code and ensure that we make the right changes to range, tab names etc are changed consistent with the comments that Bansal has written in green alongside the VB code (2025).
Once we have done this, then we should be able to minimise the VB window and make multiple selections in our spreadsheet straight away. If we want to 'unselect' one of our multiple selections, we simply click on it again, and it toggles off.
I was amazed when this worked, straight out of the box. And it still works :-)
Sam
References:
Bansal, S. (2025, June 12). Creating Multiple Selection Drop-Downs in Excel (It's Possible - Here's How). YouTube/TrumpExcel. https://youtu.be/KoTKTwx7cA0
Microsoft Support. (2024, April 19). Show the Developer tab. https://support.microsoft.com/en-us/office/show-the-developer-tab-e1192344-5e56-4d45-931b-e5fd9bea2d45
Stratvert, K. (2025, February 4). How to Create a Drop-Down List in Excel (2025 Tutorial). YouTube. https://youtu.be/CaD4-5UAK0I
Wong, C. (2024, November 11). 2 Simple Ways to Create an Excel Drop Down List. SpreadsheetPoint. https://spreadsheetpoint.com/excel/drop-down-list/
















