How to Create A Multi-Select Drop-Down List in Excel

[@SharonSmith]

WATCH NEXT - Be sure to watch this video next to see how to hide your extra "list" tabs from your form: kzbin.info/www/bejne/npKXfat5hayXhsU

[@TelecomExchange]

I watched another video of a guy explaining this and I don't know what he was talking about. You are fantastic at what you do. Thank you so much for this.

[@SharonSmith]

Oh, thank you so much! That is a great compliment. I'm glad you found my videos helpful. Thanks for watching my Channel! Take care!

[@sajali6565]

by far the best and easy to follow code and explanation, after 7 videos from others, either something is missing or not explained well enough in simple English. Great work and thank you.

[@SharonSmith]

So glad to hear you found my video helpful! Thanks for taking time to leave a nice comment. I appreciate it very much. Thanks for watching!

[@drfwiradjaja]

Finally, instructions for a mac operating system! Thank you so much, I managed to create my list with your step-by-step instructions and applied the rule to a whole column, which I found after scrolling down the comments, where someone very helpfully provides an additional instruction.

[@SharonSmith]

Glad you found what you needed! Thanks for watching!

[@carolvanleer3386]

This was the best explanation I’ve seen after researching about 5 or six videos on how to do this. Thank you!!

[@SharonSmith]

Thank you so much, Carol! That is a nice compliment. I'm so glad you found my videos helpful. Thanks for watching!

[@dr4g0nf1y68]

Thank you for creating this easy-to-use step-by-step video. I really appreciate your ability to articulate this process.

[@SharonSmith]

I'm so glad you found it helpful! Thanks for subscribing to my Channel and for watching my videos!

[@yahooezone]

Thank you so much this is great info. !! just to let others know if you want extend this feature to all rows of column or to a large no. of rows of the column then use Target.Column = 3 And (Target.Row >= 1 AND Target.Row

[@grzewicz1109]

That's exactly what I needed. Thank you!

[@yahooezone]

@@grzewicz1109 wc ! I am glad it's useful :-)

[@SharonSmith]

Thanks for sharing this tip!

[@baharhacivelioglu2837]

Great tip, just saved my life :)

[@baharhacivelioglu2837]

How would you apply it to multiple columns? For example ın addition to Column 3 also Column 4-5-6?

[@naalimamarvin]

Wanted entire column also. Thanks for the content

[@GreenTheChain]

Thanks so much!! this worked perfectly and you explaied it so clearly

[@SharonSmith]

So glad to hear that! Thanks for watching!

[@Pattythomas5]

Perfect! This worked perfectly for my drop-down list and I was able to edit it to include even more cells. You made me look like a hero today! (And I said I got the code from a KZbinr - my bosses were just happy it worked!) Thanks again!

[@SharonSmith]

Hi Patty, that is awesome! So glad my video helped you out. Thanks for watching and taking time to leave a nice comment! Best of luck to you!

[@harithfahad2621]

Thanks a lot for such a great video. However, is there a way to deselect a row previously selected?

[@honbruno]

Hello from France, you saved my day ! Your explanations are crystal clear !

[@SharonSmith]

Thank you very much, Bruno! Glad my video saved you day! Thanks for watching!

[@joshuaminnies1388]

Very useful thank you Sharon! Let's say I want this to apply this code to a range of cells in a column. What would I use as the target address? Surely there must be a simpler way than choosing to Or each Target.Address

[@mirunabelea9820]

same question

[@sohaildeen6829]

By far the best explanation I've seen on this subject, easy step by step instructions to follow. And you are also very pleasant to listen to and watch :)

[@SharonSmith]

Thank you, Sohail! That is very nice of you. I’m glad you like my videos!

[@kristyevanstherealtor]

Thank you so much for this video. Someone asked my question, and it was answered, and I was able to do what I set out to do. Thank you!

[@SharonSmith]

That is great to hear! Glad you found it helpful! Thanks for watching!

[@Tommie_Rogers]

Thanks for this Sharon. I had a student ask me how to do this today and I could help her right away. Have subscribed to your channel now and will follow your new content.

[@SharonSmith]

That is great, Thomas! So glad to help. Thank you for subscribing to my channel and watching my videos. I appreciate it!

[@lumkaluzipho475]

Thank you so much for taking us through the steps in the most basic way. I went though many videos and I was just not winning, until I watched this. A quick question, how do i drag the VBA formula so that is applies to the next cells for example and not just 1 line. Thanks

[@mukohlovet9380]

Thanks Sharon for creating this video. It was very helpful.

[@SharonSmith]

Glad you found it helpful! Thanks for watching!

[@amgody1000]

Great videos, This was so absolutely helpful. I created a code for multiple selections in drop list, separate lines, my question is how to deselect ( with Strikethrough )items were selected for tracking issue, Thanks

[@leobotelho]

The content was great. Thank you. And you standing on the side of the video os a cool feature, so it’s not only a voice but an actual person, but it was distracted a little, as you are pretty cute. Lol

[@jillboyle45]

Great instructions. Followed and 1 time through and it worked.

[@SharonSmith]

That is great news, Jill! I'm so glad you found it helpful. Thanks for watching and for taking time to leave a comment. I appreciate it!

[@hpaek1891]

Thank you! The only issue; I have a column of about 50 rows where they all need multiple validated data. Is there a way to have an entire column of say 60 lines items be able to do that?

[@marie-claudebaillargeon6140]

Hi Sharon, your instructions are really clear. It work out great for me. I was wondering how I could modify the code to have this feature on a full column and not target cells ? For example cells E1 to E250. Thank you for you help !

[@GM-js6jn]

You can if you change the row in the VBA that says "if target.address..." with; "If Target.Column = 1 Or Target.Column = 2 Or Target.Column = 13 Then". The numbers refer to the column number, i.e. A = 1, B = 2 and so on.

[@kristyevanstherealtor]

This was my question, and I did exactly what you said, and it worked. I am so happy! Thank you!@@GM-js6jn

[@junior7807]

Thank you so much. 🙌@@GM-js6jn

[@AtomicGirlPow]

Does Column A need to be written in quotes? For example, If Target.Column = "1" @@GM-js6jn

[@anshumansingh5379]

Thanks exactly what was i was looking for, very hard to find on youtube

[@SharonSmith]

Glad you found it helpful! Thanks for watching!

[@rakeshsalvi6026]

immense pleasure to join your channel, the way you explaining its awesome .

[@SharonSmith]

Thank you so much for subscribing to my channel and watching my videos! I'm glad you find my videos helpful!

[@rakeshsalvi6026]

@@SharonSmith how can I apply or drag down this code for apply several columns

[@mgcservices7524]

Thanks, as always Sharon, very clear instructions and love your website. Avid follower 👍

[@SharonSmith]

Thank you Malcolm, for leaving a comment. I'm glad you found the video helpful. Thank you for taking time to leave a comment. I really appreciate your supporting my channel!

[@israelortiz4552]

This is very helpful. Quick question, how can I apply this to the whole column? Is there a code to apply to the column or it has to be done manually using Or Target.Address =...? I want to apply this from row 3 to 195. Please let me know.

[@0247ozge]

Select target as a column such as B:B or A:A

[@fardadamirsaeedi2418]

Great tutorial. it works great. However how do I deselect an item already picked from the list once it has been selected?

[@nitinmishra7862]

Hi, any idea how to deselect once selected?

[@zettehanghj-brooks7385]

Thank you for a very concise and great video. You ensure to include all the essential info (e.g. save the file as macro for instance), so that this becomes easy to replicate. Also thank you for the code in the text here on KZbin. I have tried other videos on this and just could not get this to work on my own sheets - so Thanks for a great video. It worked now !! ;)

[@SharonSmith]

Glad you found it helpful! Thanks for watching!

[@SORTED.]

Thanks for posting this. It was very helpful.

[@SharonSmith]

Glad you found it helpful! Thanks for watching!

[@maryanndjonne5350]

I don't know if you'll get this comment. Your video was extremely helpful (better than any others I watched on the subject!) and I was able to create 5 columns with multi-select drop down lists. My question is how to adjust the code (if possible) to have the same list show up in each row within a column?

[@SharonSmith]

Hello! Please try this code (the "Set rng..." line is modified to include all cells in column A through E, as an example): Private Sub Worksheet_Change(ByVal Target As Range) Dim Oldvalue As String Dim Newvalue As String Dim rng As Range Dim cell As Range Application.EnableEvents = True On Error GoTo Exitsub ' Specify the columns to apply the multi-select drop-down list (A to E) Set rng = Intersect(Columns("A:E"), Target) If Not rng Is Nothing Then If Target.SpecialCells(xlCellTypeAllValidation) Is Nothing Then GoTo Exitsub Else If Target.Value = "" Then GoTo Exitsub Application.EnableEvents = False Newvalue = Target.Value Application.Undo Oldvalue = Target.Value If Oldvalue = "" Then Target.Value = Newvalue Else If InStr(1, Oldvalue, Newvalue) = 0 Then Target.Value = Oldvalue & vbNewLine & Newvalue Else Target.Value = Oldvalue End If End If End If End If Exitsub: Application.EnableEvents = True End Sub I hope this helps! Thanks for watching my videos!

[@maryanndjonne5350]

@@SharonSmithThank you! I found another video that had me edit to read " If Target.Column = 3 Or Target.Column = 5 , etc" Now my problem is that I want to edit the text in a header that isn't part of the drop down, but because its the whole column, it won't let me edit the words. If you know how to target specific cells within a column, that'd be great. Meanwhile, I'll keep searching!! Thanks so much!

[@ΝίκοςΓιουρούκος-ψ4γ]

You actually answered it below some comments my question!, thank you it works! :)

[@SharonSmith]

Glad you found the solution in the comments and that everything worked for you. Thanks for watching!

[@somewhereupthere]

Such a great instructor, always keeps me engaged ❤

[@SharonSmith]

Thank you, glad to help!!

[@heatonmusic]

This was great video thank you. I'm actually trying to make full columns multi select drop down columns E - G does anyone have the correct code for allowed multi select for full columns?

[@tzmproudmom1307]

So helpful! I didn't know you could add them on a separate line within the cell. Thank you! How would we apply this to several cells within the same column (i.e. G5 to G13)? And how do we edit/add to the code to make an item, if clicked again, disappear?

[@stoenixlikephoenix4551]

I second these questions, if anybody knows. Thanks!

[@shampoonka]

Would like to know the answer to this question too! Otherwise, super helpful!!

[@brittanyingold807]

@@shampoonka I hit clear contents for that cell and started over although I wish i could uncheck it!

[@shampoonka]

@@brittanyingold807 for sure that would be helpful to be able to unselect!

[@obinnauche9719]

@@stoenixlikephoenix4551 Change this line to the range of cells like this: If Not Intersect(Target, Range("G3:G100, H3:H100")) Is Nothing Then This ensures that the Column G and H from cell 3 to cell 100 has the same drop-down list

[@MajidJavdany]

Well explained and thank you Sharon. I have however an issue and still not able to multi select the inputs as described. What could be the issue !?

[@skd515]

Thank you so much. This was really helpful, Sharon! But could you please help me with the code for deselecting the option from multiselect dropdown? Something which can be included in the above code?

[@bryanwilson6256]

Extremely helpful and VERY cool!!

[@SharonSmith]

Thanks for watching, Bryan! Glad you found it helpful!

[@karenoregan3903]

Hi Sharon, great video and very helpful! 👍 I have a sheet with various columns I need dropdown menus for. Some cells require a dropdown with single values and some need multiple choice answers. Is there a way to adapt the VBA code to allow for single and multi-select dropdowns in the same sheet? Thanks!

[@michellecandidasilva6920]

Did you find out how to do it?

[@leeajojo]

Great content. Quick question - Does anyone know how to de-select a name from the drop-down list?

[@laurensorrentino6508]

Tysm for this video! Is there a quick way to have the vba code copied to a new sheet? I'm using a form with this vba code within a sheet as a template that will be duplicated on multiple other sheets and have found when I c&p, the vba code does not come with.

[@letlet7721]

Hi Sharon - this video was so helpful. I have a list of names and for that list of names I want the drop down multi select for each person. When I tried to do this it only gave the multi selection for one person. Do you have a video that shows how to do this for multi lines ?

[@SharonSmith]

Hello. Building on the VBA code example from this video, to create a multi-select drop-down list for each person in Excel using VBA, you can modify the existing code to handle multiple cells and their respective drop-down lists. Here's how you can adapt the code: Private Sub Worksheet_Change(ByVal Target As Range) Dim Oldvalue As String Dim Newvalue As String Dim cell As Range Application.EnableEvents = True On Error GoTo Exitsub ' Check if the changed cell is within the specified range If Not Intersect(Target, Me.Range("A1:A100")) Is Nothing Or Not Intersect(Target, Me.Range("D1:D100")) Is Nothing Then Application.EnableEvents = False For Each cell In Target ' Check if the cell has validation If Not cell.Validation Is Nothing Then ' Check if the cell is not empty If cell.Value "" Then Newvalue = cell.Value Application.Undo Oldvalue = cell.Value If Oldvalue = "" Then cell.Value = Newvalue Else ' Check if the new value is already in the cell If InStr(1, Oldvalue, Newvalue) = 0 Then ' Append the new value with a line break cell.Value = Oldvalue & vbNewLine & Newvalue Else ' Restore the old value if the new value already exists cell.Value = Oldvalue End If End If End If End If Next cell End If Exitsub: Application.EnableEvents = True End Sub In this modified version of the code, the code checks if any cell within the ranges A1:A100 or D1:D100 has been changed. It iterates through each changed cell and applies the multi-select functionality individually. It ensures that the multi-select functionality works for each cell independently. Make sure to adjust the range "A1:A100" and "D1:D100" to fit the range where you want the multi-select functionality to be applied. This modification should enable multi-select functionality for each person listed in your Excel sheet. I hope this helps you out. Best of luck! Thanks for watching my videos!

[@katiekade7615]

SO helpful; thank you!

[@SharonSmith]

So glad you found it helpful, Katie! Thanks for watching!

[@SP-ru3rb]

The great difficulty about this is that, what do you do when the pivot table does not recognise these multiple values as separate values?

[@lomisherif]

Thank you so much, Very helpful, can you please tell me what should I write in the code if I need a comma instead of a newline? and as well is there a chance to have a multi-selection drop list for a full table column so instead of If Target.Address = "$A$10" Or Target.Address = "$D$10" Then I do range from "A1" TO "A50"

[@aylingurbuz695]

Exactly my questions! Would love to hear answers! Ty so much for this video!

[@puppy7505]

Target.Value = Oldvalue & ", " & Newvalue

[@ericahartman7469]

Thank you so much for this tutorial! Wondering if there is a trick to deselecting something once it has been selected? Or, if the only option is to delete the cell and re-add the list items you actually need?

[@SharonSmith]

Hello! Unfortunately there is no easy way to selectively "de-select" items from the list. You would have to clear the cell and re-select desired choices. Hoping Excel will make some enhancements to this in the future. Thanks for watching my videos!

[@joseramirezmoran5215]

Not sure if you still need to know how to deselect picks, but here is what worked for me...Right below the last Else statement and directly above Target.Value = Oldvalue insert the following lines: Oldvalue = Replace(Oldvalue, Delimiter & Newvalue, "") Oldvalue = Replace(Oldvalue, Newvalue & Delimiter, "") Oldvalue = Replace(Oldvalue, Newvalue, "") Change the "Delimiter" to whatever delimiter(s) you used. Hope this helps!

[@ashajyothidhulipudi7663]

Such a neat explanation.... Thank you so much..

[@aldotrillo4642]

Hello, Congratulations, your videos are the best! Please help me with this... Hoy can I include a "Select all" option in a drop down list?, because once an option is selected I can't look all the options again.

[@Nana-ed1rr]

Hi! Thank you so much for the video! It really helped me! I wanted to know how to undo it after i select multiple ones by accidnet?

[@timvandriessen8773]

Did you find the answer ?

[@samanthahuskins1326]

Hi, this was very helpful. What would the code need to change to if I wanted the VBA code to target specific columns?

[@ArsenBeglarian]

Thanks for the great and useful tip!

[@SharonSmith]

Glad you found it helpful, Arsen! Thanks for watching and subscribing to my channel!

[@ArsenBeglarian]

@@SharonSmith Thank you very much too!

[@ali_n1104]

Sharon, this was very helpful! Thank you! Quick question, what is the code for displaying it on the same line using commas instead of new line?

[@nicolewhite6520]

I just tried this and it works - about two thirds down the code: Target.Value = Oldvalue & ", " & Newvalue Recommend that you put a space after the comma so it automatically adds for you.

[@daveault7566]

Sharon, Thank you for this wonderful video. I was able to use your code and it worked well. I do have a question, I have a form that has multiple rows which these drop down menus will be used. Is there a way to expand the code so the cells in a specific column have these drop down menus?

[@fatimaalawami8478]

Hey, did you find a way to do this? would highly appreciate your help if you have!

[@funfan10011]

This was so helpful. Thank you for posting, Sharon? If I wanted to duplicate the same dropdown list within an entire column, how would I adjust the VBA code?

[@jessaleneetcobanez6818]

use this line If Not Intersect(Target, Range("G3:G100, H3:H100")) Is Nothing Then

[@NikiBurns-m7z]

great video thanks! :)

[@SharonSmith]

Glad you found it helpful! Thanks for watching!

[@NikiBurns-m7z]

Hi @SharonSmith, can you point me in the right direction for removing items from the list without having to completely empty the cell and start again and updating a name if the name in the list changes.

[@MohAboAbdo]

Thank you so much my esteemed teacher

[@SharonSmith]

You are very welcome! Thanks for watching my videos!

[@KiranGopinath]

Thankyou! This was very useful!

[@SharonSmith]

You are very welcome, Kiran! Thanks for watching!

[@anwwattoo]

thanks so lot you helped me so much I am happy😀

[@SharonSmith]

Glad to help! Thanks for watching!

[@butterball2000]

Thanks Sharon, It doesn't seem to work when the sheet is locked. Is there anything around this.

[@Tphhfc]

Awesome tutorial. How can I have the selections come up with a comma spacing them next to each other?

[@michaelshea34]

You would replace the line of code where it says 'Target.Value = Oldvalue & vbNewLine & Newvalue' with 'Target.Value = Oldvalue & "," & Newvalue'

[@maryamdanesh6558]

I was wondering what we can do to have the Macro applied to a range of cells?

[@izzyt61]

That's exactly what I was wondering too

[@manojraturi1977]

Excellent knowledge given you!!! Thanks

[@SharonSmith]

Thank you Manoj! I'm glad you liked my video. Thanks for watching!

[@darrenhamway6514]

GREAT video - thank you so much. One question and my apologies if someone already asked. If I selected two values and one of them wasn't the one that I wanted to select, how do I remove that value? Currently, it seems that I have to delete all cell values and reselect everything. Any thoughts?

[@ashajyothidhulipudi7663]

same que form me as well, let me know if you found the answer it would be really helpful.

[@udyansingh3378]

Hello, This video was very helpful. As you did, whenever I select multiple selection from drop down list, it is getting displayed in next line, I was wondering if there is an option available that can get the multi selection displayed in adjacent cell of next column ? My purpose is to apply filter to count nos. of different selections. If this can be possible I will be able to select from one single drop down (containing 5 selection items) and later apply filter on each column to get count of each selection item.

[@pingik78]

hi great video, is there a way to create a different vba code for each column?

[@ΝίκοςΓιουρούκος-ψ4γ]

Excellent video, but how do I repeat this for the next 300 cells? it worked with one but can you explain what code to use for working for a series of cells for example from 1-300. Thank you. It is not handy to have to create 300 lines, there must be a code for that, thank you again!

[@SharonSmith]

Glad to see you found the answer. Yes, you can modify the code as needed. Thanks so much for watching and finding the answer you were looking for. Take care!

[@maryamdanesh6558]

This was so helpful, thank you so much.

[@SharonSmith]

You are very welcome, Maryam! Thanks so much for watching!

[@kathymcelveen4539]

This is great. How can I program to remove item from the cell once I don't need it there? Ex. I gave the id badge back to the employee therefore I wouldn't have it on this list?

[@hanyeltahawy8078]

Hi Sharon thank you you very much for the video it is very creative and useful I have a question, is this drop list analyzable, can we implement a search or a vlookup to it?

[@sillyehmi]

Hi! Thank you for making this video. I am wondering if this can be modified to make a dropdown checklist instead of a checklist box? I am organizing my wedding guest list and want to make sure we are accommodating for multiple disabilities, and any language barriers for 100 people. I've been having trouble trying to make it into a dropdown checklist for each person. Any ideas? Thank you for all of your help! :)

[@angelacasas3228]

is there a way to deselect a row previously selected. I am using rows instead of commas?

[@lientrinh7211]

Awesome vid and instruction. Thank you!

[@SharonSmith]

Thank you for watching! Glad you found it helpful!

[@jonathanmorgan8511]

Hi, If you are looking to use this approach for multiple rows in the same collumn, would you still need to add each cell identifier into the code or is there a way of adding a range?

[@sushantdesai3445]

Hi Sharon, it works great for me. Thank you. I need to create multiple selection drop down list but here there are checkpoints : 1. This drop down list should be editable. Meaning if i have created colour drop-down list and in the same cell i have selected 4 colours Red, Black,Blue,Cream. I want to replace Black>Yellow in this case how to replace this value? by using VBA codes or list box. 2. In this drop down list i need to insert duplicate colours. Meaning if i have selected Red,Black,Blue,Green,Red here in this case i have selected 'Red' twice. In this case how you will replace Red colour? You can suggest some functionalities that can meet this requirements. I hope this is one of the challenging task i have put infront of you. Hope you will crack it. Waiting for your reply.

[@K177R]

Thanks for this video! One question: could you explain the section of the code that reads " Newvalue = Target.Value, Application.Undo, Oldvalue = Target.Value"? Does the Application.Undo remove what was just entered into the target object, which then causes Target.Value to become what was in the target cell previously?

[@tuckstravelsnz]

This has been very helpful, I was not able to find an answer to the additional questions. Q: I have applied this to a column, this works, but I want to then be able to filter based on the chosen outcomes, the filter reads each cell as one body of text, are we able to separate the outcomes to allow for filters to work?

[@annalisaqueen2529]

Thank you so much this video. It has been very helpful. I was able to use your code for an entire column of data. However, I have two other columns that need to include multiple drop-down selections in each cell. How do I modify the code to do this? Thank you.

[@makymatnov]

Hi! How did you apply this to an entire column?

[@InquisitiveCris]

Hi Sharon. What if I have 1000 cells in a column that I need to apply this to?

[@hereismika]

Any tips to apply this formula to an entire column without having to individually type out each cell?

[@leightonleukes3650]

This was very helpful, thank you. I have a question though. How would I write this for a big range of cells, eg multi selection for range A1:A900?

[@dereckchamboko9160]

I applied to the entire column. change 6 to :If Target.Address Like "*L*" Then where "L" was my column

[@DaniWalker-mi5kz]

Hi there! Great video! It's working perfectly, but when I try to remove one item I get an error. Im using this tool as a task organizer like: name, address, phone. Is there a way to remove an item from the list. Like once I get the name Id like to take it off of the list. When I try and backspace or "delete" the item I get an error code.

[@alexanderdavies1447]

Thank you. Can this be done as a single checklist instead of repeated opening of the list?

[@tajgoodlow6462]

Great video on the topic! Two questions. 1) Is there a line of code that can be added to restrict the number of selections? Like, lets say I have a list that I only want the user's top 3 from the list of dozen plus options. Can that be done where the forth selection won't be able to be made because you restrict them to 3 (or x ) selections? 2) Is there someway the number of selected from that list can be counted or tallied in another cell? Thanks for your excellent videos on forms!

[@dominiqueallaire4185]

Thank you for this video. What I am looking for is to do the same but for all the cells of a column. How do to do? Excuse my english.

[@JanineBerger-q8h]

Hi Sharon, I'm curious - how would you suggest modifying the VBA code to apply to an entire column and not just two single cells as you did in this video? Thank you so much for your clear videos!!

[@SCharlesS]

You can if you change the row in the VBA that says "if target.address..." with; "If Target.Column = 1 Or Target.Column = 2 Or Target.Column = 13 Then". The numbers refer to the column number, i.e. A = 1, B = 2 and so on.

[@mychanneltoletyouknow]

ya'know you have high turnover when you need a drop down list 😅😂🤣. thanks for sharing.

[@SharonSmith]

Glad you liked it! Thanks for watching!

[@bryanwilson6256]

This was an awesome video, but I had an additional question: How do you de-select an item (i.e. remove it from the list) after the list has been populated?

[@yvettelee3990]

If you mean removing things from the original list, you can either edit your original list and remove the item or you can change the range that your data validation identified when you created the original list. if you mean change the results from the multi-select you chose, I clicked away from the created selections and clicked back to the list and hit "backspace". While I couldn't remove a single line, I could remove everything and start over.

[@bryanwilson6256]

@@yvettelee3990 Thank you!

[@RaphaelZwyer-z1u]

As far as the code you provided, it can be applied to any list on sheet and is not limited to one cell, correct? It appears that for the line "If Target.Address = "$A$10" Or Target.Address = "$D$10" Then" there is a max amount of cells one can add/target. Is there a way around that limitation? I tried some shorthands (like "$A-G&10" or $A,B,C,D,E,F,G$10" or $A&10-20") but while it doesn't give me a code error, it doesn't allow to pick more than one list item in the dropdown. Also, the amount of list items in the dropdown seems limited to 12 items.

[@stevejohnson7608]

Hi Sharon, I'm having trouble getting this script to work when I protect other parts of the workbook. Can you tell me how to keep Protection from disabling the script? Thanks!

[@Kidakaizo2321]

Thanks for this info, but how to apply this to all row? like for example i wanted to have a multiple drop downlist in all rows of column A? Is there any specific code for that? If I follow (for example) the "or Target.Address = "$A$2 and so on until row 200.. " its too much code... hope you can help me.. thanks!

[@elchibekniyozmamadov3183]

Thank you so much !!!

[@SharonSmith]

You are very welcome! Thanks for watching!

[@GabrielLG-o2y]

it is possible to do this in Word with a drop box?

[@ChrisL-x5k]

Ive done this but I also need to protect parts of my sheet and when I enable the protection (only other cells are locked, not cells with the drop down) the multi selection stops working. Is there a way around this?

[@hamun34]

Hello Sharon! Thank you for making this video. This video was very helpful. I want to create a material lists and their quantities. But when i use the same quantity for different materials, I've been having trouble trying to update the cell with the same quantity. For example: I have "samsung" and "Iphone" mobiles as a material lists on my 1st cell (A2). I want to apply "1pc" as a quantity for both materials on the 2ns cell (E2). samsung 1pc Iphone 1pc any VBA code which might fix this issue? Thanks !!

[@jandenmark4928]

Great video, how do you apply the macro to all rows in that column? Not just 1 cell? Thanks

[@SharonSmith]

Hi Jan! Great question! On about the sixth line of code that says: If Target.Address = "$A$10" Or Target.Address = "$D$10" Then Replace with: If Target.Column = [insert number of column] Then by number of column, I mean count over and use a number instead of the letter, so for example column A = 1, B = 2, C=3, etc. then all cells in that column will have the code applied. Hope this helps! Thanks for watching!

[@jandenmark4928]

@@SharonSmith many thanks Sharon, what if I wanted to start on row 2 of the columns to allow for column titles? 🤔

[@resulbasak4193]

@@SharonSmith Hi Sharon great information than you very much, I have tried so many advice from various expert yours is the greatest one. I have one question to ask; I have added multiple drop box menu for my sheet so used If Target.Column = [insert number of column] or [insert number of column] Then the moment I have added second column my excell functions gone made, even adding to different cells is not proparly working. If I used it for one column than everything goes back to normal... How can I fix the isseu? I need multiple drop box menu like this and other functions of the excell as well. thank you very much in advance.... Also if anyone has suggestion I am all ears : )

[@MandaM0221]

What is you need it on a whole column? Do you have to add each for of that colum?

[@sulmawarne6096]

Thanks Sharon - very useful. Could you explain how to apply the vba code Multi-Select Drop-Down List in Excel to an entire column as oppose to having to manually input each cell reference into the code. I have a worksheet where I want the VBA code to apply to over 100 cells in one column

[@yourupbeat2631]

Did you got the way? M looking for same solution..

[@shamaragough7451]

Target.Column = 3 And (Target.Row >= 1 AND Target.Row

[@sabrinagonzalez2492]

Worked with ease!@@shamaragough7451

[@jokersamxd]

Hi Sharon, is there any ways we could analyse these multiple selections as separate values using pivot table?

[@florence8537]

Thank you so very much!!!

[@SharonSmith]

You are very welcome! Thanks for watching!

[@lonettem]

Thanks for your guidance on creating a multi-select drop-down list. However, I need to program more than 35 cells on the same sheet. The process you provided worked for 18 cells, or none at all if I added a script that includes 36 cells. Please help.