Thanks! I truly value that you explain the code. Others simply show the code, but you make sure that your audience understands what is happening
@MyOnlineTrainingHub
Ай бұрын
Great to hear! 🙏
@srezanoori
Жыл бұрын
Clear, concise, and to-the-point. Thank you.
@MyOnlineTrainingHub
Жыл бұрын
So pleased you enjoyed it, Reza!
@kensleylewis
2 жыл бұрын
Why is this the only video on KZitem that talks about apply multiple pre-selected options into a single Excel Cell. Excellent work.
@MyOnlineTrainingHub
2 жыл бұрын
Probably because it's not best practice to stuff multiple criteria into a cell 😉 but glad we could help.
@kensleylewis
2 жыл бұрын
@@MyOnlineTrainingHub I can see truth in that. Many thanks.
@IvanCortinas_ES
4 жыл бұрын
It is very practical. Well, it allows us to see, for example, the names of two people who have participated in a process (both of them) and we can use data validation for this. Thank you for this great contribution Mynda!!
@MyOnlineTrainingHub
4 жыл бұрын
So pleased you can use it, Ivan :-)
@mistyboni5862
Жыл бұрын
Thank you so much for this! I have been trying to find a way to do this for months!
@MyOnlineTrainingHub
Жыл бұрын
Glad I could help!
@AngelaSpring
3 жыл бұрын
Hi Mynda, Thanks for this video. It helped me a lot :) Wanted to ask how you would add another multi-select list to the worksheet/VB? So say one multi-select list is for Contacts (Ie, Tom Smith, Karen Wood) and then in the next column (to the right) it contains a multi-select list for Class format (In class, Online). Is it even possible? Thanks!
@JosLuisOfficial
4 ай бұрын
Thanks for the tutorial, very useful just one question, how to select multiple values? I tried with Ctrl+ shift combination but it don’t worked :(
@MyOnlineTrainingHub
4 ай бұрын
You select them one after another i.e. select one, then click on the drop down again and select the next one.
@nicholechristoph56
11 ай бұрын
This is exactly what I was looking for to clean up a spreadsheet! One question...how would the code change if you wanted to apply the same feature to more than one column?
@martystone8789
3 ай бұрын
Hi, there’s another Video describing it: “How to Create A Multi-Select Drop-Down List in Excel” by Sharon Smith. Just found it for my own use as I had the same question. Kind regards
@rubendominguez5564
Жыл бұрын
Thank you very much for this tutorial! This is wonderful, clean, easy and organized! I loved it!😊
@MyOnlineTrainingHub
Жыл бұрын
Great to hear, Ruben!
@AdvanceOffice
4 жыл бұрын
Very informative mam, i tried making a drop down list tutorial especially in hindi.
@MyOnlineTrainingHub
4 жыл бұрын
Glad you liked it :-)
@AdvanceOffice
4 жыл бұрын
@@MyOnlineTrainingHub just cause this amazing tutorial if by you mam :)
@subramanirangasamy3320
4 жыл бұрын
More learning thanks you very much
@MyOnlineTrainingHub
4 жыл бұрын
Glad to hear that :-)
@brucehardy1640
4 жыл бұрын
That was very nicely done. Thanks.
@MyOnlineTrainingHub
4 жыл бұрын
Thanks so much, Bruce :-)
@yquintana5673
10 ай бұрын
This is great! How can I still make the items be counted separately when I insert the data into a chart? Right now, it counts all items in the one cell as one category.
@MyOnlineTrainingHub
10 ай бұрын
Not easily, which is why Excel wasn't designed to have multiple items in one cell. You would have to split them again and then count. You could use the new TEXTSPLIT function wrapped in COUNTA: www.myonlinetraininghub.com/textsplit-textbefore-and-textafter-functions
@EricHartwigExcelConsulting
4 жыл бұрын
Such a great video! Thank you for sharing this with everyone!
@MyOnlineTrainingHub
4 жыл бұрын
Glad you enjoyed it, Eric!
@meriemziane2424
3 жыл бұрын
Hello :) Very usefull video. I have a question though. I would like to apply this code for multiple column in my excel file. How do you duplicate it to work for the other columns also ? I managed to do it only for one as you explained in you video. Thanks for your answer !
@muratucar227
4 жыл бұрын
Thank you. Good technic for multiple selection. Congratulations.
@MyOnlineTrainingHub
4 жыл бұрын
Many thanks!
@flomast3r
2 жыл бұрын
How do you use vba with a two column spreadsheet? If i want vba to check cell A1 to see if it contains a value matching any in the first column, and then scroll to the cell listed in corresponding row of second column?
@SumitNandy-rn1nf
Жыл бұрын
Great!! Is there a way that I can press a button to to pop-up a drop-down where I can have multi-select and once clicked outside, it updates the cell with multiple values with a separator?
@MyOnlineTrainingHub
Жыл бұрын
Probably, but I don't have a tutorial I can point you to that will explain how. If you get stuck trying it yourself, you can always post your question in our Excel VBA forum: www.myonlinetraininghub.com/excel-forum
@bernibrand3724
2 жыл бұрын
Great explanation and was able to implement it on my worksheet, however, prior to this had a VBA code to make the cell with the drop down list better readable by having it zoom once cell is selected. Now the trouble is, that either I can work with your VBA code for multiple selection or VBA code for better reading, but unfortunately not booth together working. Is there a workaround or some tutorial to learn about this combination? Thank you in advance
@sahildawany1032
3 жыл бұрын
Great tutorial! Very informative. Thank you!
@MyOnlineTrainingHub
3 жыл бұрын
My pleasure, Sahil!
@sahildawany1032
3 жыл бұрын
@@MyOnlineTrainingHub I noticed that if you have multiple options in the list that have common words, the script removes the common word. For example, I have a list with various PCR test types (COVID-19 PCR, DDPCR, RT-PCR & PCR), I can choose the first 3 without any issue (cell content shows as COVID-19 PCR, DDPCR, RT-PCR) but if I try to select PCR after selecting the 3, the script removes the "PCR" from the previous entries and the cell content becomes (COVID-19 DDRT-PCR). Would you be able to help me overcome this challenge?
@omarnemo7732
2 жыл бұрын
hey there. how to make it possible on multiple columns or ranges? If Not Intersect(Target, ActiveSheet.Range("J:J")) Is Nothing Then here is J column is effected by vba code. but how to make and N column also possible to select multiple items.
@nayanamurthy28
3 жыл бұрын
Thank you so much for your video it very helps full for me...
@MyOnlineTrainingHub
3 жыл бұрын
You are most welcome, Nayana!
@knunne1
4 жыл бұрын
Great video, I will put it to work today. Thank you!
@MyOnlineTrainingHub
4 жыл бұрын
So pleased it's useful to you!
@darrylmorgan
4 жыл бұрын
Hi Mynda!Great Bit Of VBA..Thank You :)
@MyOnlineTrainingHub
4 жыл бұрын
Cheers, Darryl!
@perpetualpeace6711
Жыл бұрын
do u think its possible to do this in Word instead of Excel, using the same tecnique?
@MyOnlineTrainingHub
Жыл бұрын
Maybe 🤔
@LuisFernando-yd3mx
Жыл бұрын
How do we change the code so that it places the other options selected on each additional rows below and not on the same cell.
@MyOnlineTrainingHub
Жыл бұрын
If you don't need them all in the one cell, then simply use a regular data validation list in each cell: www.myonlinetraininghub.com/excel-drop-down-lists
@dashrathpanchal8393
4 жыл бұрын
Hi..very unique ...great !! thanks for sharing
@MyOnlineTrainingHub
4 жыл бұрын
:-) thanks, Dashrath!
@lalaplectann985
2 жыл бұрын
Hello Mynda, Very helpful for dimensions, what about for dates? Is there any way to link this to an array for dates? For example, If I wanted the user to select multiple dates and get relevant data only for those dates - if my drop-down consisted of weeks of the year and I select multiple weeks and return --let's say--Total sales for those weeks using SUMIFS - where one of my criteria could be the "multi-select" weeks drop-down? Thanks.
@MyOnlineTrainingHub
2 жыл бұрын
Please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@brianryerson7484
2 жыл бұрын
Thank you for the great video and this has been very helpful to me. I have I hope a quick questions. Instead of the "," between each selection is there a way to use the "vbNewLine" and have them on the separate lines? I tried to mod your code but I can not seem to get it to work right. Thanks again.
@martystone8789
3 ай бұрын
Hi, there’s another Video describing it: “How to Create A Multi-Select Drop-Down List in Excel” by Sharon Smith. Just found it for my own use as I had the 😂same question. Kind regards
@itsharish_008
2 жыл бұрын
Is it possible to create multiple select option to single drop down cell without using a VBA code?
@MyOnlineTrainingHub
2 жыл бұрын
No.
@shakiraasfoor7599
4 жыл бұрын
Well Done Myanda
@MyOnlineTrainingHub
4 жыл бұрын
Thank you!
@fyrweorm
3 жыл бұрын
Thank you for the code explanation. Is it possible to adapt this code to do multiple selections in dropdown lists inside an excel table (listObjects)? I don't have enough knowledge to do it by myself
@MyOnlineTrainingHub
3 жыл бұрын
You can, but it's not really suitable in a table.
@merbouni
4 жыл бұрын
Hi Mynda, thank u for this great video, it's a very useful idea for some works. But I think we can only use this if we have a short and limited items in the data validation list (10 items in max for example). The problem is..... what if we have a lot of items to select, and we choosed a wrong item..? in this case, we cannot undo or edit the content of our DV cell by pressing F2 Key or with any other way..! Mynda, i think the VBA code needs some modifications, I'm waiting for your solution, why not, maybe in your next video.
@MyOnlineTrainingHub
4 жыл бұрын
Glad you found it useful. A workaround is to copy the incorrect selections to another cell, edit it, then copy it back.
@merbouni
4 жыл бұрын
@@MyOnlineTrainingHub Well, I expected this solution, " Look for a simple way to fix bugs " ;)
@omarnemo7732
2 жыл бұрын
@@merbouni there is already update to select again and item will be deleted
@wayneedmondson1065
4 жыл бұрын
Hi Mynda.. very clever.. VBA to the rescue! Thanks for sharing. Thumbs up!!
@MyOnlineTrainingHub
4 жыл бұрын
Cheers, Wayne! Sometimes only VBA will do :-)
@crips192
4 жыл бұрын
Thank you Ms.
@MyOnlineTrainingHub
4 жыл бұрын
My pleasure :-)
@MukunthanIyer
4 жыл бұрын
This is great. But, once we capture data with multiple values, can we pivot them once again back with alpha, bravo, charlie individually? Say, in this current example, the count us rows with 'Alpha, Bravo' will be 1. Instead, can we show it as Alpha: 1, and Bravo: 1?
@MyOnlineTrainingHub
4 жыл бұрын
Glad you liked it. I think the moral of this story is that you shouldn't really store your data like this because it prevents you later making use of it in formulas :-) If counting it is the end goal, then store the values in individual cells. If you want your cake and eat it too, then use Power Query to split the data by the comma delimiter into rows where it can then be counted.
@AldrenGalano
3 жыл бұрын
Thanks for making this video. I'm using a macbook and I only see one selection each time I try.. Maybe the code isn't compatible on my Excel 2017? Would be glad to hear from you....
@MyOnlineTrainingHub
3 жыл бұрын
I'd say it's a Mac limitation.
@abdullahbestil4824
2 жыл бұрын
@Aldren Galano Hi, I just tried this code with Mac, and it worked on Microsoft 365 apps, FYI
@stephaniedaou5228
3 жыл бұрын
Thank you for the tutorial. I have a question, if i want to have this option on many cells not just one, how can i proceed? Thank you
@MyOnlineTrainingHub
3 жыл бұрын
You can copy the cell containing the list and paste it.
@chrism9037
4 жыл бұрын
That was great, thank you!
@MyOnlineTrainingHub
4 жыл бұрын
Glad you enjoyed it, Chris!
@bumblejoo
4 жыл бұрын
Thank you so much. But I run into problem when I tried to delete one name, for example, I selected three names but I decided to delete the third one, this will give error. It will only allow to delete all instead. Anyone encounter this?
@MyOnlineTrainingHub
4 жыл бұрын
Hi Joel, if you select the name again from the list it removes it from the cell.
@EngineerGen
2 жыл бұрын
Is there a way to make it so that when i selected a text that is already included/selected before it will remove that text?
@MyOnlineTrainingHub
2 жыл бұрын
Hi Gene, probably, but I don't have a tutorial I can point you to. Please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@farzanmoha8935
4 жыл бұрын
Thank you Myanda, I am thinking where can I use this multiple selection in my reports or any dashboard.
@MyOnlineTrainingHub
4 жыл бұрын
Glad you'll be able to make use of it, Farzan :-)
@mihajlovicrus
2 жыл бұрын
Hi Mynda, Thanx for tutorial. What if I have depended drop down list, it is not working in my file, is there a solution to it ? I have 1 independed and 2nd depended cell based on first one ? It is showing there is Bug ? Appreciated in advance.
@MyOnlineTrainingHub
2 жыл бұрын
Please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@davidhoneger113
3 жыл бұрын
thank you
@MyOnlineTrainingHub
3 жыл бұрын
You're welcome, David!
@JatinKumar-kg8oh
Жыл бұрын
Can wo do this in sheets?
@MyOnlineTrainingHub
Жыл бұрын
Sheets doesn’t have VBA, so I’m not sure how you’d go about it.
@shanawazbashi8037
3 жыл бұрын
Mam i follow u on KZitem. Im struggling to find a way to solve this issue. Is it possible to use Formula and Data Validation in the same cell...? As i want to call a product by formula and also give option to choose another product by DV . Please help in this regard. Or refer a video
@MyOnlineTrainingHub
3 жыл бұрын
Not sure what you're wanting to do, please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@waltermakuzander5248
4 жыл бұрын
I just want to ask question about drop down list, I hope you could help me. Is there a way that can be a warning sign or a message once I change the first cell (with drop down list, say Quarter 1 to Quarter 2) that I need to change the next cell (with dependent drop down list)? Given that Quarter 1 (January, February, March) Quarter 2 (April, May, June) I suddenly change the Quarter, is there a function that will tell me to change the month inclusive to that quarter? Please help 😊
@MyOnlineTrainingHub
4 жыл бұрын
No, there's no way to do his with the built in functionality of Excel. You'd need to edit the VBA code.
@user-ry2te6lz7h
4 жыл бұрын
Thanks 😊
@MyOnlineTrainingHub
4 жыл бұрын
You're welcome :-)
@cryptodon0074
3 жыл бұрын
HELP I have done everything you said but I am getting an error on the line code below?? If Not Intersect(Target, ActiveSheet.Range("DV_Range")) Is Nothing Then
@MyOnlineTrainingHub
3 жыл бұрын
Have you downloaded the sample file and compared it to yours? If so, please post your question and Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@johnborg5419
4 жыл бұрын
Thanks Myndy. :) :)
@MyOnlineTrainingHub
4 жыл бұрын
My pleasure, John :-)
@dannyleblanc336
2 жыл бұрын
i can not undertand why multiple items in a drop down list it's not offer in Excel whitout VBA!!?? But thank's for this code ;)
@MyOnlineTrainingHub
2 жыл бұрын
Glad it was helpful, Danny!
@lumierenk5652
3 жыл бұрын
great !!! but what to do if the excel is online (in sharepoint) ? please advice
@MyOnlineTrainingHub
3 жыл бұрын
You'd need to open the file in the desktop Excel app. VBA cannot be executed online.
@lumierenk5652
3 жыл бұрын
@@MyOnlineTrainingHub yesssss it works thank you sooo much
@luwannaclark5356
3 жыл бұрын
Hello, I'm confused, I copied the code into my workbook but it didn't work. Am I supposed to change the settings in the code and if so, where?
@MyOnlineTrainingHub
3 жыл бұрын
Hi Luwanna, please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@eeminchiam
3 жыл бұрын
Hi, I have a question which is I would like to add a title infront of the selection, for example a cell name Fruit that contain "Apple, Banana, Orange" and a cell name Vegetable that contain "Broccoli, Cabbage, Lettuce". But the Fruit and Vegetable cannot be selected. What am I meaning is that Fruit and Vegetable is basically like a header for those selection. I hope my question is clear enough. Thank you.
@MyOnlineTrainingHub
3 жыл бұрын
I think what you're after is dependent data validation lists: www.myonlinetraininghub.com/excel-dependent-data-validation
@eeminchiam
3 жыл бұрын
@@MyOnlineTrainingHub Hi, thank you for the respond. I wish to done this in only one column, is that possible? Thank you.
@okezienwachukwu6272
3 жыл бұрын
The issue is when I apply this code it makes all drop down lists within the table multiple selection. How do I ensure it works for just a selected column?
@MyOnlineTrainingHub
3 жыл бұрын
Hi Okezie, please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@hardnewstakenharder
3 жыл бұрын
I’m sorry, but this is still extremely confusing to me. I have no idea what is happening when I press Alt-F11, nothing there makes sense to me and I have no idea how I’m supposed to apply all that code to my own excel spreadsheet. Could you do another video that explains this as if it were explained to a five year old?
@MyOnlineTrainingHub
3 жыл бұрын
Please see this tutorial that explains what to do with code you find on the internet: www.myonlinetraininghub.com/how-to-use-vba-code-from-the-internet If you're still stuck, please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@hardnewstakenharder
3 жыл бұрын
@@MyOnlineTrainingHub Thank you!
@merrisahakyan2016
4 жыл бұрын
Alt+F11, does not open the code on my windows 10, I have tried Fn+Alt+F11 as well, but this open Visual Basic.
@MyOnlineTrainingHub
4 жыл бұрын
Hi Merri, Visual Basic is the window you should be opening.
@pratikjadhav6501
Жыл бұрын
I need a way to make multi-dropdown list without changing my file's extension. No-one in youtube has tried so , how lame
@MyOnlineTrainingHub
Жыл бұрын
They haven't tried because it's simply not possible.
@pennyanderreeperbahn8360
3 жыл бұрын
For some reason, after restarting the excel sheet, your VBA code doesn't work anymore. It is still there and everything but the multi select part doesn't work. Anyone knows what do to? Edit: Maybe the VBA code is not running automatically?
@MyOnlineTrainingHub
3 жыл бұрын
Please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@tarekhemaida7072
4 жыл бұрын
How Can we use this code for multiple cells or column..
@MyOnlineTrainingHub
4 жыл бұрын
Hi Tarek, If you download the sample Excel file available from the link in the video description, you'll see it has been used in multiple cells in that file. Hope that points you in the right direction. If you get stuck, please post your question and sample file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@ajmainhossain780
3 жыл бұрын
Would you please give me a copy of the code in this box ....that would be a very good help for me dear
@MyOnlineTrainingHub
3 жыл бұрын
The link to the Excel file containing the VBA code is in the video description.
@rohithk.7991
4 жыл бұрын
is this possible in Google Sheets?
@MyOnlineTrainingHub
4 жыл бұрын
Don't think so, Rohith.
@amdanielgaming
3 жыл бұрын
How to do the same on sheets
@MyOnlineTrainingHub
3 жыл бұрын
I don't use Sheets, so I'm not sure.
@jujuiscool6206
3 жыл бұрын
It's not working for me :(
@MyOnlineTrainingHub
3 жыл бұрын
Sorry to hear that. You can post your question in our forum and we can try to help you there: www.myonlinetraininghub.com/excel-forum
@phvaguiar
4 жыл бұрын
Cool
@MyOnlineTrainingHub
4 жыл бұрын
Thanks, Pedro :-)
@danjky2774
3 жыл бұрын
I open VB but see nothing, why is that?
@MyOnlineTrainingHub
3 жыл бұрын
You haven't created any code yet?
@leonardogranados2733
3 жыл бұрын
Nice but too complicated for me
@MyOnlineTrainingHub
3 жыл бұрын
Personally I don't recommend this technique, but we get asked about it from time to time, hence the video.
@rameezkruddson7567
2 жыл бұрын
😘😘😍
@MyOnlineTrainingHub
2 жыл бұрын
Glad you liked it :-)
@MuhammadAli-hg1td
2 жыл бұрын
My version of the code which puts the selected items on the same line and separates them by a comma for columns A to Z: 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("A:Z")) 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
@MyOnlineTrainingHub
2 жыл бұрын
Thanks for sharing 😊
@MuhammadAli-hg1td
2 жыл бұрын
@@MyOnlineTrainingHub You're welcome :)
@GunGirlYuna
4 жыл бұрын
If you click the same thing twice will it be in the cell twice?
@MyOnlineTrainingHub
4 жыл бұрын
No, there is a line of code that prevents that, but you can remove it if you prefer. It's all commented in the Excel file (download link in the video description) so you can see exactly what I'm referring to.
Пікірлер: 147