Forum Discussion
tick all that apply
am fairly new to this and can create lists that allow a person to select one item from a list, but I now want to create the possibility to a 'tick all that apply' question. For instance: who is attending the meetings, tick all that apply, and allow people to choose more than one from a list
How can I do this in excel?
Thank you
Marieke
1 Reply
Excel's Data Validation drop-downs don't allow for multiple selection natively. It can be done using VBA - see for example Excel Data Validation - Select Multiple Items
