Select Multiple Items in an Excel Drop Down List - Easy VBA Trick Anyone Can Use - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 10
REDA
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.
reply
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.
reply
Walter
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 -
reply
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 -
reply
Berni
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
reply
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
reply
Ee
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.
reply
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.
reply
Angela
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!
reply
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!
reply
it_industry
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?
reply
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?
reply
Brian
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.
reply
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.
reply
Meriem
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 !
reply
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 !
reply
Mukunthan
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?
reply
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?
reply
mihajlovicrus
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.
reply
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.
reply
Add a review, comment
Other channel videos
