Thread: Multiple correct in data validation drop down box

Hello,

I need to know how to have multiple correct responses in a data validation drop down box. For instance, here is my list:
As needed
Daily
Weekly
As ordered by Physician

Any combination, including all four could be the correct response and would need to show on the spread sheet as a chosen response.

Can anyone help me?

Carla

Hi,

if you use data validation with a list, you can only select one of the choices on offer. The functionality you're after calls out for a multiple choice tick box, but I'm not sure if you want to go down the VBA track with Userforms.

For a VBA free solution you either need to include all possible combinations in your list (which would make it quite long), or have four separate cells where the user can select the values, for example

cell/column1
as needed

cell/column2
daily

cell/column3
weekly

cell/column4
as ordered by physician

The user fills in as many cells/columns as apply in the case and if only two values are selected, the other two cells/columns simply stay blank.

Would that work?

cheers

Teylyn