October 15, 2021
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.
December 7, 2016
I am no coder myself but it seems to me that this article is describing what you are looking for, on how to set up a drop down list allowing multiple choices.