How to Select Multiple Items From an Excel Drop Down List

An Excel drop-down list allows you to make one selection at a time. You can not select multiple items from the same drop down list in Excel.

However, you can use VBA to make this happen.

In this video, I will show you how to use VBA code to select multiple items from a drop down list in Excel.

The video will show you how to select multiple items with and without repetition.

In addition, it will also show you how to modify the code to make the drop down work in different cells/rows/columns.



⚙️ Gear I Recommend:

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

[Babor]

I never write comments on YouTube but this has been one of the most useful videos I have seen. And the information presented on the site is great. Thanks and keep up the great work.

[ContinuumSpanner]

Fantastic Tutorial, so many people underestimate how to make tutorials and explain things in slow, clear and concise ways. I know it's a random video to be leaving praise on but after the multitude of tutorials I've been searching up recently it's refreshing to see someone who does it well. Keep up the good work!

[vinayakkumar]

Thank you, this was helpful.I got stuck with the saving of the file as it would not execute the code until it saved it (not sure why) and would have to save it in macro enabled workbook format. But it works now....

[nickwebb]

You sersiously presented this in the cleanest way possible. Thank you for this

[frandanisa]

What a great video and big thank you for including all the variations to the code. I use the multi-selection, non-repeating code and made it for the whole column (same column across multiple sheets) and it worked perfectly! By the way, this is the first time I've written a review for any of the thousands of videos I've watched, it's just so good I felt like I had to give you props and had to subscribe!

[karlamedina]

THIS VIDEO IS LITERALLY A LIFESAVER! Im working on my thesis and after 2 hours of watching videos that didnt help at all, I finally managed to do al the dropdown lists I needed. Thank you!!!!

[jo-anneyau]

You are a genius and an amazing teacher. I've gotten lost after watching about a dozen videos, and you are by far the most helpful. Thank you!

[alyssahughes]

Excellent tutorial. Exactly what I was looking for. Thank you!!

[lilianahughes]

This tutorial was amazing! I looked at over 20 video looking for how to make this complete a column and could not find a way to do that. I came to yours and it provided me exactly what I was looking for. Again this video was amazing and I am grateful to you.

[DLowryVA]

This was incredibly helpful! Thank you so much. Looking forward to learning a lot more!

[gabyparamo]

Thank you so much! This was exactly what I was looking for !

[vportillo]

Thank you! So easy to follow and explained each step-by-step in perfect detail! Exactly what I needed for a request at work!

[petardjordjevic]

Dude, you are genius! Thanks a lot! Your code is so helpfull! Bravo for sharing!!! Greetings from Serbia bro😊

[mishraamukesh]

Your videos makes my days nice.
I had learnt as much as i know in excel all from your videos. Then experiments do the rest.

Thank you very much.

[MohammedAhmed-tues]

Such amazing tutorial, can't give it enough praise! thanks a lot for supporting the learning community :)

[elizabethmcknight]

I feel like a wizard. This is so incredibly helpful. Thank you!

[ernieviveiros]

Love it brother. Thank you for this. I enjoy your style of teaching. Very complete. Don't stop.

[marooned_space_princess]

This was super helpful. Instructions were clear and easy to follow. Thank you for sharing!

[flufwix]

The video is a must see to make this work. THANK YOU

[williamhusseyjr]

DUDE! This was to the point, fast - my kind of learning!!! With out a doubt THE BEST EXCEL training video I have watched YET!!!! I will be subscribing ... THANK YOU SO