Excel now blocks macros by default when you download a workbook from the internet. Therefore none of these macros will run in the workbook I have provided unless you unblock the macros. Please see this page for guidance learn.microsoft.com/en-us/deployoffice/security/internet-macros-blocked
Follow the link in the description to download the featured file. Open the file, open the VBE (ALT F11) and the code for each sheet can accessed by selecting the relevant sheet in the Project Explorer.
Very helpful and easy to understand! I will say I used this in a table and while in the table I also had the Design Mode on which caused some issues. After scratching my head for 15 minutes, I disabled it and the VBA of course worked lol! Thank you for this tutorial!
Just wondering if the code can be updated so that you can deselect items by selecting them in the drop down menu again? For example if you select the wrong from the list can you correct it. If so, do you happen to have the code?
Thank you. Precisely what I needed and your instructions and variations on the theme were extremely clear. So efficient to hear from someone who can both code and teach well.
Dear Chester, The Video is well designed and crystal Clear for me. I Was able to use the same function on my VBA code. It is working fine. Only want to know, how to unselect the Value from the same drop down.
I finally got it to work. Thank you so much. Guys you need to rename the list of options. Thats very important. Follow his steps carefully. You can definitely get it to work.
Great video! Got a question though. I would like to be able to delete the values in the drop down list (the newline version) so that when i select a value for the second time, the value is deleted from the list. I tried and i tried but i can't figure it out. Could you teach me how to do this? Regards.
Hi ! Great tutorial. Thanks! But, in the case of an error in my selection, how do I take that item out of the selection if clicking the item a second time doesn't do it? Thanks again.
Amazing information!!!! Thank you very much, Chester!!! I follow your instructions, however, even after copying your Macro, I am still unable to select multiple values :( Not getting any errors, but I can only display/show just 1 value at a time. Any suggestion would be appreciated
Thanks Chester for sharing the VB code. It helped me have a comma seperated list quickly. I would like to have the code to delete one of the items from the multiple selection in a cell, just like how I can add multiple selections for a cell. Thank you 🙏🏼
Hi Chester, thanks so much this was incredibly helpful! I do have one question, what if I need 2 drop down lists in the same sheet (2 different columns), I tried editing the Range on the macro like "B2:C2" since the columns are next to each other, but it gave me an error.... could you help me out?
here you go change this line this work for me. "If Not Intersect(Target, Range("K:K,L:L,M:M")) Is Nothing Then" you need to just write your column letters in this line
Great tutorial, you helped me enormous with this. Thanks a lot. When I protect my worksheet unfortunately each new choice in the list replaces my last choice instead of adding the choice to the first one. So, it is like the behavour of the list without VBA code. Is there a solution for that? So, the sheet is protected, the specific cells with list in it are unlocked.
this is really helpful. but i am having challenges in multiselect functionality when I am opening my excel on web version (multi-select is not working) However, it is working fine in Desktop version. Do I have to do anything different for Excel online version
Thank you for this video. I was struggling to add my multi-selections to multiple cells in my spreadsheet. After watching this video, I realised how simple the fix was. Thank you.
You're code helped me out a lot! How would I be able to remove an item from the list using the dropdown menu? For example I have selected Brenda, Betty, Bethany. But I want to remove Bethany to make it Brenda, Betty again by selecting Bethany's name in the drop down list.
Really useful! One question - to select multiple values from the dropdown you are having to click them individually. How can you select them all at once rather than one by one?
Chester, this was so easy to understand, thank you! Can you explain or do you have a video that provides the code if I added a second or third name from the dropdown (as you've shown above) and then I decided to remove that person or realized I added that individual in error?
This has been so helpful to me. I have a question and a huge need to be able to ‘deselect’ a name that I previously selected from the drop-down list. What and where do I place this code?
Thank you so much, I finally got this to work for a project at work. I'm curious if this can be tweaked for multiple ranges. This code was by far better to work with than a few others online.
Thank you for sharing the great video! I have a question about deselecting a name without receiving an error message. I would really appreciate your feedback!
@ChesterTugwell. Thanks for the video! It was very helpful!> Do you have an add to the code that allows me to de-sellect one of the options if I click on it again? Currently if I need to remove one or undo a selection, I just have to delete the content and start over.
Thank you Sir, I do have another related issue: if I want to have 3 separate columns, not next to one another, using the same multiple entries code in the VBA, how should I then change the code in VBA?
Can you please suggest how may I handle this problem: I was able to implement the code in column using If Intersect (Target, Range ("A:A"). How may I apply similar code in column B and C. Appreciate your help.
This is a great video and so easy to follow but I could not get this to work. I couldn't get the drop down list to display more than one item at a time. I have the correct cell etc but no luck.
Thanks for the analysis! I have a quick question: I have a SafePal wallet with USDT, and I have the seed phrase. (behave today finger ski upon boy assault summer exhaust beauty stereo over). What's the best way to send them to Binance?
Hi, Super clear video, thank you so much!! I have a slicer installed for the dropdown list, but in the slicer the names also appear now as "Bachus, Brenda", where I would still like the individual names in de slicer and then all the cells which contain them, even if it has multiple names, to apaer when I click them. Any instructions?
Thank you Chester. I just not understanding where the code comes from in the visual basic editor to generate multiple names in the cell. Can you explain again for me
amazing video. Is it possible to create a dynamic drop down multiple selection checkbox based on a filter? for example if I select region as south, I want to display a list of checkboxes consisting of states that are in the south region. the list should change when I select another region
Hi, Thank you very much this great tutorial, I no nothing in excel and was able to follow and create the dropdown list. I do have an issue thoug, the cell formula seems to disappear every time I change worksheet. Is this normal? Am I missing something? Thanks for any help you can provide.
Great stuff! So thorough and well planned to make the learning process very easy. I've subscribed and looking forward to more videos. BTW - your accent is quite pleasant and easy to listen to.
I have finally got the code to work after some corrections so that it is the same as seen on the video. Many thanks for that. Is there additional code that would allow the user to enter something manually into a cell. At the moment I have it set to allow non validated data but when I add this, it repeats everything that is in the cell.twice
Thank you so much for this! I have used it to create multiple selections in one column. However, I wanted to ask, is it possible to create such multiple selections in drop-down lists in multiple columns on the same sheet?
I did it by using this code: If Target.Column = "9" Or Target.Column = "10" Then (These numbers 9 and 10 are actually column letters I and J - so just replace letters with numbers) :) I hope this helps!
I thought the same thing. How would one apply the multiple selections within the dropdown to multiple cells, like 500 at a time? Or just to an entire column?
I had the same problem and I just figured out a way to solve it: just modify the code in this way to apply the multiple selection drop down in two - or more for that matter - columns: If Not Intersect(Target, Range("N:N", "P:P")) Is Nothing Then In my case I needed the multiple drop down in the columns "N" and "P" and it just works fine. Hope this helps. Anyway, just wanted to say thanks a lot for the video as well!
Hi, thank you for this, it worked! Now, I want my chart to pick out the data as individual items instead of grouped into one. Is this possible? Or, do I keep each item on its own row?
Thanks. I have done every steps you taught, but when I run the code it says I have to add macro name. But as far as I know the macro name is for when I create a button in Excel, whereas now I'm just working on a cell.
Great video. I use the drop down list on calendar for open shits at work . Just wondering how I can unselect a shift once it is picked up with out having to clearing the entire shift.
Great video! This was extremely helpful! Is there a way to have multiple drop down list in the same tab with multiple selection capabilities but each drop down has a different data source?
Thanks a lot. this was very useful for me. But I have a problem. When I lock the sheet I can not select multiple , I can select one item. If possible, please help me .
Hi Chester. Thank you for this tutorial. It worked great for entering multiple data items in one column. Can you please advise how I alter the VBA code to add a second list to populate a cells in a second column with multiple items listed in each of the second column's cells?
I got it: In the VBA, you can change so the range concerns several columns in the same sheet but not necessarily next to each other. I did as follows: If Not Intersect(Target, Range("E4:E53, N4:N53, AE4:AE53")) Is Nothing Then So the quotation marks have to be at the very beginning and very end of the areas you wish to include in this code. Hope this helps.
Thank you so much for this amazing tutorial! Almost works, adds multiple selections, except I receive an error message when entering multiple selections into the cell: Restriction: Value must match one of the listed items. Any idea why it would do so? Thank you ever so much!
Hi Chester, great video indeed. I'm running into a issue when applying this approach to a range within a table. For two or more values in the data validation result in the cell, I'm getting a data validation error that I cannot figure out how to code around. Upon inspection the Data Type = List, Restriction: "Value must match one of the listed items.", "Blanks will be ignored and are automatically valid." Setting the Error Alert tab and disable "Show error alert after invalid data is entered." But that doesn't remove it. The only thing that works is to go into options -> Formulas, and disable the "Data entered in the table is invalid." To demo this is indeed related to the VBA in a table, if I convert the table to a range. It works without an issue. But I need the range to be a table for adding more records.
As many of the others have commented, great video. This was very helpful. For my purposes, how do I add the code to columns that are not adjacent to each other? In my case, the comma separated choices would be in columns H, K & L.
here you go change this line this work for me. "If Not Intersect(Target, Range("K:K,L:L,M:M")) Is Nothing Then" you need to just write your column letters in this line
This is of great help! But I also need to apply the same code to another column. How do I go about this? Should I type the entire code again, changing the column name?
Thank you so much! It finally worked out! Maybe you also know how to transfer this code to google docs (so it would be possible to use this excel file online)? You would be a great help! Thanks!
Hi - this is a great tutorial. I am trying to download the file but keep getting stuck in a "prove you're not a bot" loop - literally 15 minutes of clicking images at this point. Is the link broken? Is there another way to get the file? I promise I'm not a bot (and not an idiot!)
Thank you Mr. Chester for this great resource :) My version of the code which puts the selected items on the same line and separates them by a comma for columns B to D: Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Dim Oldvalue As String Dim Newvalue As String Application.EnableEvents = True On Error GoTo Exitsub If Not Intersect(Target, Range("B:D")) Is Nothing Then If Target.SpecialCells(xlCellTypeAllValidation) Is Nothing Then GoTo Exitsub Else: If Target.Value = "" Then GoTo Exitsub Else 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 & ", " & Newvalue Else: Target.Value = Oldvalue End If End If End If End If Application.EnableEvents = True Exitsub: Application.EnableEvents = True End Sub Also if you're getting an invalid procedure name error, then save the macro as: "macro_select_multp_items_dropdown_sep_by_comma" and save the file in a macro enabled excel file which has an extension of .xlsm on Windows
Thank you for this video. I noticed a few people in the comments asked how a value from the drop down list can be removed, and it wasn't answered. Can someone answer how the code should be changed so that if a value is selected by mistake, it can be removed without having to delete the contents of the cell and start over?
hello Chester, where do I find the code that you used so that I can copy and paste it instead of typing it and maybe making errors? Please advise Thank you cheers Margaret
Thank you very much, this was very beneficial to me. Being that the last time I had done anything with VB was 25 years ago in college, this really helped with having the basics of what I needed and instructing me on how to modify it based upon different requirements. The only issue that I came across was that macros are not supported unless opening the Excel document on a pc desktop app. I cannot access these functions from a cell phone or iPad unless converted over to Java. The document I created was to be utilized while inspecting and documenting room statuses and being able to document multiple common issues that occur in a single space. I had high hopes to be able to capture the updates from my phone's Excel app rather than walk around with a laptop across the campus. Has this code been modified to Java yet because of these issues, and is Java the way going forward because of the VB macro restrictions to anything but a pc desktop Excel app? Thanks!
Seems I am unable to make a chart with the data of the column that has the drop down inputs. Any advice? Basically I'm a mechanic and I am using the multi select to choose what services were done. I'd like to be able to see a graphic that displays how many times I've done oil changes and tires, etc....
Help please: It is a question to extend the function the the code across multiple areas of a work sheet. Can you please tell me how to identify a range of cells plus a number of other single cells in the the worksheet?
here you go change this line this work for me. "If Not Intersect(Target, Range("K:K,L:L,M:M")) Is Nothing Then" you need to just write your column letters in this line Odpowiedz
@Chester Tugwell is there a way to count the number of entries made in a multiple selection cell (as shown in your video). Use case, if I wanted a simple count of the entries selected.
I have three sheets in one workbook that are using the same drop down list in the same column. I have gotten the code to work for one sheet but not the other two. Any advice on how to get this to work on all three sheets?
Hi there, I have followed every little bit of instruction, and multiple selections still wont work - Should the file be saved in a specific format? TIA.
Excel now blocks macros by default when you download a workbook from the internet. Therefore none of these macros will run in the workbook I have provided unless you unblock the macros.
Please see this page for guidance learn.microsoft.com/en-us/deployoffice/security/internet-macros-blocked
Follow the link in the description to download the featured file. Open the file, open the VBE (ALT F11) and the code for each sheet can accessed by selecting the relevant sheet in the Project Explorer.
Thank you so much! This one's really helpful!
Hi Chester, the code doesn't seem to be included in the workbook that was attached to the email sent after subscribing?
Very helpful and easy to understand! I will say I used this in a table and while in the table I also had the Design Mode on which caused some issues. After scratching my head for 15 minutes, I disabled it and the VBA of course worked lol! Thank you for this tutorial!
Just wondering if the code can be updated so that you can deselect items by selecting them in the drop down menu again? For example if you select the wrong from the list can you correct it. If so, do you happen to have the code?
Hello, were you able to figure out how to deselect items?
@@abby7849 No, want to see how we can achieve deselect items, please help
You. Are. A. Godsend! Thank you so much for investing your precious time to provide this info to the public for free.
Thank you. Precisely what I needed and your instructions and variations on the theme were extremely clear. So efficient to hear from someone who can both code and teach well.
Totally agree!
Dear Chester, The Video is well designed and crystal Clear for me. I Was able to use the same function on my VBA code. It is working fine. Only want to know, how to unselect the Value from the same drop down.
I was looking for this answer as well. Did you ever figure it out?
Same situation. How do we unselect?
@ChesterTugwell - i have the same problem. can you do a video/ point us as the video to show how we do this please.
I mean ... who has actually disliked this video? Brilliant tutorial, easy to follow, worked first time. Cracking.
I finally got it to work. Thank you so much. Guys you need to rename the list of options. Thats very important. Follow his steps carefully. You can definitely get it to work.
Great video! Got a question though. I would like to be able to delete the values in the drop down list (the newline version) so that when i select a value for the second time, the value is deleted from the list. I tried and i tried but i can't figure it out. Could you teach me how to do this? Regards.
were you able to do it? i am also thinking of a way to delete used values.
U saved me, thank you so much. I have been struggling for 3 days. Finally, I made it with the help of your code and Video.
Hi ! Great tutorial. Thanks! But, in the case of an error in my selection, how do I take that item out of the selection if clicking the item a second time doesn't do it? Thanks again.
Amazing information!!!! Thank you very much, Chester!!!
I follow your instructions, however, even after copying your Macro, I am still unable to select multiple values :( Not getting any errors, but I can only display/show just 1 value at a time. Any suggestion would be appreciated
For me the macro worked after I saved the document as xlsm.
Thanks Chester for sharing the VB code. It helped me have a comma seperated list quickly. I would like to have the code to delete one of the items from the multiple selection in a cell, just like how I can add multiple selections for a cell. Thank you 🙏🏼
Hi Chester, thanks so much this was incredibly helpful! I do have one question, what if I need 2 drop down lists in the same sheet (2 different columns), I tried editing the Range on the macro like "B2:C2" since the columns are next to each other, but it gave me an error.... could you help me out?
here you go change this line this work for me.
"If Not Intersect(Target, Range("K:K,L:L,M:M")) Is Nothing Then"
you need to just write your column letters in this line
Great tutorial, you helped me enormous with this. Thanks a lot. When I protect my worksheet unfortunately each new choice in the list replaces my last choice instead of adding the choice to the first one. So, it is like the behavour of the list without VBA code. Is there a solution for that? So, the sheet is protected, the specific cells with list in it are unlocked.
Excellent video, just what I was looking for. I was beginning to think I was attempting the impossible until I came across this video. Thanks!
Hey, I followed every step perfectly. And it works but sometimes it does not. Feels like an excel glitch, do Macros do that?
Very helpful! I was wondering if you could do this in mutiple columns? If so, how? And thank you! this tutorial was easy to follow.
this is really helpful. but i am having challenges in multiselect functionality when I am opening my excel on web version (multi-select is not working)
However, it is working fine in Desktop version. Do I have to do anything different for Excel online version
Thank you for this video. I was struggling to add my multi-selections to multiple cells in my spreadsheet. After watching this video, I realised how simple the fix was. Thank you.
Omg thank you SO MUCH for the brilliant tutorial and all the code variations! This was both a life saver and incredibly easy to follow 🤩
Hi there, where did you find the code on the tutorial?
You're code helped me out a lot! How would I be able to remove an item from the list using the dropdown menu? For example I have selected Brenda, Betty, Bethany. But I want to remove Bethany to make it Brenda, Betty again by selecting Bethany's name in the drop down list.
Really useful! One question - to select multiple values from the dropdown you are having to click them individually. How can you select them all at once rather than one by one?
Chester, if I want to then place this into a pivot chart, how does the graph count each name within the cell on the graph??? Great videos mate 👍🏻👍🏻
Chester, this was so easy to understand, thank you! Can you explain or do you have a video that provides the code if I added a second or third name from the dropdown (as you've shown above) and then I decided to remove that person or realized I added that individual in error?
Well put together and nicely paced to keep adding functionality. THank you.
Thank you a lot, just a remark from my side... there is no option to put away the name from dropdown menu if you chose it once ?
Really useful! Do you have any video or code for removing selected items from a multiple drop down list?
This has been so helpful to me.
I have a question and a huge need to be able to ‘deselect’ a name that I previously selected from the drop-down list. What and where do I place this code?
Thank you so much, I finally got this to work for a project at work. I'm curious if this can be tweaked for multiple ranges. This code was by far better to work with than a few others online.
Thank you for sharing the great video! I have a question about deselecting a name without receiving an error message. I would really appreciate your feedback!
@ChesterTugwell. Thanks for the video! It was very helpful!>
Do you have an add to the code that allows me to de-sellect one of the options if I click on it again? Currently if I need to remove one or undo a selection, I just have to delete the content and start over.
I would like to know how to do this myself! Have you learned how to deselect without deleting the content and starting over?
Thank you Sir, I do have another related issue: if I want to have 3 separate columns, not next to one another, using the same multiple entries code in the VBA, how should I then change the code in VBA?
Thank you very much! Great video! Do you think removing names from the cell by choosing them from the list is possible?
thank you very much great video just I wanted to know if I want to select 2 values and do the sum what is the function that I use thank you again
This video literally saved my life! LOL. Question: is it possible to list choices in alphabetical order regardless of click order?
The drop down list with comma separator, exactly what I'm looking for!! Thank you so much!!
Can you please suggest how may I handle this problem: I was able to implement the code in column using If Intersect (Target, Range ("A:A"). How may I apply similar code in column B and C. Appreciate your help.
Asna- Thank you! Your comment solved my problem! Much appreciated!
Chester, you da man! Thanks for a very clear and easy to understand video. Worked perfectly.
Hi Chester, this works great, with one exception. Once I make the sheet protected, the multiselection stops working. Any tips?
This is a great video and so easy to follow but I could not get this to work. I couldn't get the drop down list to display more than one item at a time. I have the correct cell etc but no luck.
Thanks for the analysis! I have a quick question: I have a SafePal wallet with USDT, and I have the seed phrase. (behave today finger ski upon boy assault summer exhaust beauty stereo over). What's the best way to send them to Binance?
Hi, Super clear video, thank you so much!! I have a slicer installed for the dropdown list, but in the slicer the names also appear now as "Bachus, Brenda", where I would still like the individual names in de slicer and then all the cells which contain them, even if it has multiple names, to apaer when I click them. Any instructions?
Thank you Chester. I just not understanding where the code comes from in the visual basic editor to generate multiple names in the cell. Can you explain again for me
amazing video. Is it possible to create a dynamic drop down multiple selection checkbox based on a filter? for example if I select region as south, I want to display a list of checkboxes consisting of states that are in the south region. the list should change when I select another region
GREAT VIDEO! THANKS!
IS IT POSSIBLE TO RUN THE VB CODE IN A SHAREPOINT EXCEL FILE (ONLINE)?
Nope only in Desktop app it is working
Hi, Thank you very much this great tutorial, I no nothing in excel and was able to follow and create the dropdown list. I do have an issue thoug, the cell formula seems to disappear every time I change worksheet. Is this normal? Am I missing something? Thanks for any help you can provide.
Great stuff! So thorough and well planned to make the learning process very easy. I've subscribed and looking forward to more videos. BTW - your accent is quite pleasant and easy to listen to.
This is an amazing Video. If I want my Range to be the entire sheet All Rows and All Columns.How would I write the code?
I have finally got the code to work after some corrections so that it is the same as seen on the video. Many thanks for that. Is there additional code that would allow the user to enter something manually into a cell. At the moment I have it set to allow non validated data but when I add this, it repeats everything that is in the cell.twice
After 15 attempts I got it right. Crikey snapbags thank you!
Oh my god , works so well.😂❤
This boosted my confidence to start programming. Lol
Thank you so much for this! I have used it to create multiple selections in one column. However, I wanted to ask, is it possible to create such multiple selections in drop-down lists in multiple columns on the same sheet?
I did it by using this code: If Target.Column = "9" Or Target.Column = "10" Then (These numbers 9 and 10 are actually column letters I and J - so just replace letters with numbers) :) I hope this helps!
I thought the same thing. How would one apply the multiple selections within the dropdown to multiple cells, like 500 at a time? Or just to an entire column?
I had the same problem and I just figured out a way to solve it: just modify the code in this way to apply the multiple selection drop down in two - or more for that matter - columns:
If Not Intersect(Target, Range("N:N", "P:P")) Is Nothing Then
In my case I needed the multiple drop down in the columns "N" and "P" and it just works fine. Hope this helps.
Anyway, just wanted to say thanks a lot for the video as well!
Hi, thank you for this, it worked! Now, I want my chart to pick out the data as individual items instead of grouped into one. Is this possible? Or, do I keep each item on its own row?
Thanks. I have done every steps you taught, but when I run the code it says I have to add macro name. But as far as I know the macro name is for when I create a button in Excel, whereas now I'm just working on a cell.
Great video. I use the drop down list on calendar for open shits at work . Just wondering how I can unselect a shift once it is picked up with out having to clearing the entire shift.
Great video! This was extremely helpful! Is there a way to have multiple drop down list in the same tab with multiple selection capabilities but each drop down has a different data source?
Thanks a lot. this was very useful for me. But I have a problem. When I lock the sheet I can not select multiple , I can select one item. If possible, please help me .
Thank you, it was really helpful. I just have a question - is it possible to select "All" with a single chose ?
Hi Chester. Thank you for this tutorial. It worked great for entering multiple data items in one column. Can you please advise how I alter the VBA code to add a second list to populate a cells in a second column with multiple items listed in each of the second column's cells?
I got it: In the VBA, you can change so the range concerns several columns in the same sheet but not necessarily next to each other. I did as follows:
If Not Intersect(Target, Range("E4:E53, N4:N53, AE4:AE53")) Is Nothing Then
So the quotation marks have to be at the very beginning and very end of the areas you wish to include in this code.
Hope this helps.
@@Beyonder1881 THANK YOU!!!!!!!!!!!
@@Beyonder1881 Ahhhhh! Thank you SO much for posting this! You solved my question too!
Thank you so much for this amazing tutorial!
Almost works, adds multiple selections, except I receive an error message when entering multiple selections into the cell:
Restriction: Value must match one of the listed items.
Any idea why it would do so? Thank you ever so much!
Hi Chester, great video indeed. I'm running into a issue when applying this approach to a range within a table. For two or more values in the data validation result in the cell, I'm getting a data validation error that I cannot figure out how to code around. Upon inspection the Data Type = List, Restriction: "Value must match one of the listed items.", "Blanks will be ignored and are automatically valid."
Setting the Error Alert tab and disable "Show error alert after invalid data is entered." But that doesn't remove it. The only thing that works is to go into options -> Formulas, and disable the "Data entered in the table is invalid."
To demo this is indeed related to the VBA in a table, if I convert the table to a range. It works without an issue. But I need the range to be a table for adding more records.
As many of the others have commented, great video. This was very helpful. For my purposes, how do I add the code to columns that are not adjacent to each other? In my case, the comma separated choices would be in columns H, K & L.
here you go change this line this work for me.
"If Not Intersect(Target, Range("K:K,L:L,M:M")) Is Nothing Then" you need to just write your column letters in this line
@@micharoltechnik751 Thank-you
Very complete manual of data validation with macros. Thank you very much.
awesome video, but is there a way to do this without using Visual Basic?
Many thanks in advance.
This is of great help! But I also need to apply the same code to another column. How do I go about this? Should I type the entire code again, changing the column name?
How can you select multiple values at once? Can we use ctrl+shift?
How do you now delete options you’ve selected? Let’s say that you clicked one by error for example
Thank you so much! It finally worked out! Maybe you also know how to transfer this code to google docs (so it would be possible to use this excel file online)? You would be a great help! Thanks!
The video is amazing but i have a question about how to create or get a cod?
where do I find the code mentioned in the beginning of this video? I dont see it in the description
Hi, this was very helpful! What would the code need to change to if I wanted the VBA code to target specific columns?
The perfect video for the season.
Thank you for this
It worked perfectly. But I'm having an issue in saving the file and using it as a shared file. Any tips?
Make sure you are saving as an Excel Macro -enabled Workbook
Chester - superb video tutorial - just what I was looking for - thank you.
thanks a lot for the tutorial. I have a question if you could answer. How can I delete a value once inserted? If I try I receive an error message.
Excellent tutorial. Thank you so much!
Hi - this is a great tutorial. I am trying to download the file but keep getting stuck in a "prove you're not a bot" loop - literally 15 minutes of clicking images at this point. Is the link broken? Is there another way to get the file? I promise I'm not a bot (and not an idiot!)
It worked!!! Awesome tutorial. Thank you, Thank you!
Thank you Mr. Chester for this great resource :)
My version of the code which puts the selected items on the same line and separates them by a comma for columns B to D:
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
Dim Oldvalue As String
Dim Newvalue As String
Application.EnableEvents = True
On Error GoTo Exitsub
If Not Intersect(Target, Range("B:D")) Is Nothing Then
If Target.SpecialCells(xlCellTypeAllValidation) Is Nothing Then
GoTo Exitsub
Else: If Target.Value = "" Then GoTo Exitsub Else
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 & ", " & Newvalue
Else:
Target.Value = Oldvalue
End If
End If
End If
End If
Application.EnableEvents = True
Exitsub:
Application.EnableEvents = True
End Sub
Also if you're getting an invalid procedure name error, then save the macro as:
"macro_select_multp_items_dropdown_sep_by_comma" and save the file in a macro enabled excel file which has an extension of .xlsm on Windows
This is helpful! I just wanted two columns but this will do
Thank you for this video. I noticed a few people in the comments asked how a value from the drop down list can be removed, and it wasn't answered. Can someone answer how the code should be changed so that if a value is selected by mistake, it can be removed without having to delete the contents of the cell and start over?
Deleting and re-selecting is the easiest way to do it
hello Chester, where do I find the code that you used so that I can copy and paste it instead of typing it and maybe making errors? Please advise Thank you cheers Margaret
Thank you, How can I DESELECT from drop list. ?
hi, you know how to do it?
Thank you very much, this was very beneficial to me. Being that the last time I had done anything with VB was 25 years ago in college, this really helped with having the basics of what I needed and instructing me on how to modify it based upon different requirements. The only issue that I came across was that macros are not supported unless opening the Excel document on a pc desktop app. I cannot access these functions from a cell phone or iPad unless converted over to Java. The document I created was to be utilized while inspecting and documenting room statuses and being able to document multiple common issues that occur in a single space. I had high hopes to be able to capture the updates from my phone's Excel app rather than walk around with a laptop across the campus. Has this code been modified to Java yet because of these issues, and is Java the way going forward because of the VB macro restrictions to anything but a pc desktop Excel app? Thanks!
Is there a way you can set up the filter to look for just one name in the column vice all of them grouped together?
Awesome video and tool. Thank you so much for sharing.
Amazing. So clear. Thank you! Have a nice day.
Thank you!! Is there a way to use it also in dependent dropdown lists (INDIRECT)?
Seems I am unable to make a chart with the data of the column that has the drop down inputs. Any advice? Basically I'm a mechanic and I am using the multi select to choose what services were done. I'd like to be able to see a graphic that displays how many times I've done oil changes and tires, etc....
Help please: It is a question to extend the function the the code across multiple areas of a work sheet. Can you please tell me how to identify a range of cells plus a number of other single cells in the the worksheet?
Respected Sir, I really appreciate you, your creativity is boosted me.
This is helpful but what if you want to use it on multiple columns. How do you represent the range then.
Excellent stuff. Is there a way to adjust the code to allow for functionality in multiple columns?
here you go change this line this work for me.
"If Not Intersect(Target, Range("K:K,L:L,M:M")) Is Nothing Then"
you need to just write your column letters in this line
Odpowiedz
@Chester Tugwell is there a way to count the number of entries made in a multiple selection cell (as shown in your video). Use case, if I wanted a simple count of the entries selected.
Nevermind, I figured it out…….
Thanks. Just a question how will be do this for suppose if the user selects NOT APPLICABLE so he shouldn't be allowed to select anything else
I have three sheets in one workbook that are using the same drop down list in the same column. I have gotten the code to work for one sheet but not the other two. Any advice on how to get this to work on all three sheets?
Hi there, I have followed every little bit of instruction, and multiple selections still wont work - Should the file be saved in a specific format? TIA.
Same goes to me. Followed every inch of the instruction but to no avail :(
@@astridyeow1199 same. I even followed like 4 other youtube videos. Still not working for me.
@@shehriyarkhan3904 you have to save the file as a macro-enabled workbook
What code do you add to remove one item selected?
Do you know how to do it?
Beautiful video. Thanks a lot🙏🏾🙏🏾🙏🏾