VBA code to allow dropdown box multiple selection

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.