Forum Discussion
VBA code to allow dropdown box multiple selection
Hi all,
Is there an option to allow multiple selections of a dropdown box within excel?
the dropdown would be in column V (v2 downwards, and the list is in tab “Entities” from a2 down to a6.
the codes I have tried from online either didn’t allow me to remove a selected item, or when I did remove it and try to select others I ended up with “floating” commas. Ie it went from “apple, pear, banana” to “,pear ,” and I couldn’t remove the commas.
thanks
1 Reply
I'm quite sure your real world situation doesn't involve various combinations of fruit. But even if it did, having a cell with the contents "Apple, Pear, Banana" could potentially be problematic in itself, even if it's just part of a shopping list; what do you do if the first market you go to has the Apples and the Bananas, but no Pears? And so on. And would your desire be to always have the final selections be in the same category--in this case "Fruits"--as opposed to other occasions when the multiple selections might end up "Apples, Nails, 8x10 plywood"
There's a reason why upfront conceptual design is important when it comes to having a useful workbook.
It is possible to have drop downs that cascade, say three different drop downs each getting more specific. I have such a set in my budget tracking spreadsheet. Here's an image showing the concept. (There are quite a few more rows in reality). And I've attached an sample workbook that illustrates how to create what I've called a "Cascading set of Drop Downs"==if that would work in your real world situation.
