tick all that apply

Copper Contributor

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


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