Dropdown list allowing multiple items selected|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hi all,

I have just discovered this wonderful resource and have just watched three videos back-to-back and I already feel inspired!!

This is the issue that I was hoping for some help with....

I have got a data sheet of module survey feedback and have added a dropdown list in cells in one column - that's fine, as it is sentiments so you can only choose positive, negative, mixed, etc... The second column is for categories and is a pick list of the categories the feedback is about - as the feedback will usually contain more than one category this needs to allow me to make multiple picks from the dropdown list and display what I have picked in the cell - this is the bit I am stuck on!!

I have tried combo boxes, but don't really understand the difference between Form Controls and ActiveX Controls and whatever I try doesn't seem to work! What should I use that allows me to choose multiple things from a dropdown list and shows my choices in the cell?

Eventually I want to use the data in these columns in pivot tables, for example all feedback about content, assignments and tutor feedback for modules a, b and c, etc... I am SO hoping that this will be possible, as I REALLY want to set up the amazing dashboard that has inspired me in the video I have just watched!!

Any ideas on how to sort out this dropdown multi-pick list would be fantastic!

Thank you so much everyone.

Cathy 🙂