How to Create Drop Down List with Multiple Selections

In this video, I'll guide you through two steps to make multiple selections from a drop-down list in Excel. You'll learn about creating a drop-down list, enabling a drop-down list to accept multiple selections and multiple selections without repetition. Making multiple selections from a drop-down list allows you to handle and analyze selected values for project tasks, survey responses, or any other scenario requiring multiple choices. With practical examples and step-by-step instructions, you can effortlessly create multiple selections from a drop-down list in your own Excel spreadsheets.

👨‍🏫 Instructor: Farihatul Mim
🎥 Editor: Md. Riajul Islam

✨ ⯆ Resources:
Alt+F11 - To open the visual basic

▬ Contents of this video ▬▬▬▬▬▬▬▬▬▬
0:00 - Intro
0:50 - Creating Drop-Down List
1:42 - Enabling Drop-Down List to accept Multiple Selections
5:31 - Multiple Selection without repetition

📚 ⯆ DOWNLOAD the workbook here:

🌍 ⯆ Checkout the article here:

🚩 Stay connected with us on social media for more Excel tips and tricks!

🙋‍♂️ Stuck with an Excel formula or a VBA code? You can post your questions or upload your Excel file to get in touch with the professionals and get the solution you need.

👉 If you found this video helpful, don't forget to subscribe to our channel for more Excel tutorials, tips, and tricks! Hit the subscribe button and turn on notifications, so you never miss an upload. By subscribing, you'll be supporting our channel and helping us to reach more people who can benefit from our content. Thank you for watching, and we'll see you in the next video!

🔔 ⯆ Subscribe on YouTube:

#excel #exceltutorial #exceltips #exceltricks

[SebastienMAILFERT]

AMAZING!!! Your explanations are clear and it works!!!!

[rdobsoni]

Excellent Instructions!!!! 1st time ever writing a VBA ... end result was PERFECT!!!

[jamielundine]

Very helpful! I am looking for some help analyzing the results of a multiple-selection column? For example, how many cells in the column contain a specific answer? Do you have a video about this? Or any guidance. Thank you!

[amirrafiesuludin]

Great video & explanations, btw can the drop down lists combine with check box lists with multiple selections? Please advise & can you show how to do it?

[FernandaGonzalez-xn]

hello!! Excelent tutorial, it was very clear and I understood with your responses in the comments how to apply to an entire column o multiple columns.
I have a question, I can't seem to deselect an option once I have selected it. I tried selecting it multiple times and deleting it by pressing backspace, can't find my way around that :(
Thanks in advance!

[alexg]

Amazing video! How can I instead of use adding that macro to 1 cell, adding the same macro for a whole column?

[gianlucaruggieri]

Hi,
it works great!! Thanks for all of this
Would it be possible to have the concatenate selection of multiple values always in the same format ? like always in alphabetical order? E.g. : i click on "Queen", then on "She" and the outcome is "Queen, She". Then if i do the other way click on "She" and then on "Queen" the outcome is always "Queen, She"
Thank you in advance

[jinskim]

Can I apply Filter on row 1 for the multiselected items in the rows below?

[MeliPC]

This is fantastic thank you sooo much for this! I have one question. When i select multiple items into one cell although it works i am getting an error message because having multiple values in one cell does not match the originally specified drop down list which has one value per cell. is there any way to clear this error message?

[btcuvdw]

Really impressive, im having an issue with one of the function. After applying the repetitive drop down function after i add in something by accident to a cell and try to delete it the existing text in the cell is applied again to the cell. Is there are way to add an event that can delete the specified input text in that cell? Thank you for your time this is actually incredible

[tonnii_sia]

Hi! thank you. how do i do this for multiple cells in one sheet?

[tonnii_sia]

Hi! thank you for the good instructions. May i know how do i do this for multiple cells in one sheet?

[gemYT]

Nice work and very helpful. On top of that. Is it possible to add separate links to those multiple selections?

[shobanamanohar]

This is very helpful! However I am facing an issue - it was working great yesterday but suddenly now the multi select is not happening and its only single selecting when I change the selection. I confirmed that the cell address is correct in the code and the code is saved in the respective sheet module. Can you help me figure out whats going wrong?

[ylhqmvu]

Hi, I would like to apply this to a whole column on a spreadsheet. What would I put in the VBA - If Target.Address = "$M$???" Then

[riiiicc]

Hello, this is super useful. I have just one questions. What if I need an entire column to have this kind of dropdown menus (not just one cell). How do I enter the range instead a "single" cell in your case $D5$ ?

[angelbonilla]

What if I have multiple drop downs and want to restrict only certain drop downs from being able to have multiple selections while others having only a single selection?

[andiabsher]

I should have asked by question different. Can this also be used in a table. Meaning, I have a data table and I want to be able to use this option to fill in each cell in a column for the, does this make sense?

[andiabsher]

What if my lookup list is on a separate tab? I assume i have to change my Target Address but how? Do I have use enter the Sheet name and then the cell? Can you provide the code?

[RT-vgmk]

I downloaded the workbook to try out, I click on pen and then pencil, the cell D5 changed to pencil only, instead of Pen, Pencil..
I'm using Microsoft Office Professional Plus 2016.. is my software too old to use this function?