

May 29, 2019

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 |

VIP

Trusted Members

December 7, 2016

Hello Melanie,
Have you seen these articles linked to below? They show two different methods to add drop down lists in Excel.
https://www.myonlinetraininghu.....down-lists
https://www.myonlinetraininghu.....excel-form

VIP

Trusted Members

June 25, 2016

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-.....ist-excel/
Hope this helps.
Sunny
1 Guest(s)
