Good afternoon,
Hoping you can help..
I'm looking to create a drop-down list that will allow the user to select single or multiples as shown in the example below. Rather than try and list all the possible variations that might be required into a data validation list, I'm hoping there is a short cut?
| Person at Risk |
| OP/M |
| M |
| OP |
| OP/Con |
Hello Melanie,
Have you seen these articles linked to below? They show two different methods to add drop down lists in Excel.
https://www.myonlinetraininghub.com/excel-drop-down-lists
https://www.myonlinetraininghub.com/add-data-to-combo-box-drop-down-list-in-excel-form
Hi Melaine
What you want will require VBA.
You can refer this link for some examples on how it is done :
https://trumpexcel.com/select-multiple-items-drop-down-list-excel/
Hope this helps.
Sunny
