multiple selections for data validation

[ccw]

Hi- need to find out how (if possible) to use data validation but include an
option to select multiple choices in validation list (ie. checkboxes similar
to pivot table options)

 

[Eduardo]

Hi,
take a look to Debra Web

http://www.contextures.com/xlDataVal02.html

if this helps please click yes, thanks

 

[ccw]

actually, what I needed was to see if the drop down selections can be check
boxes so I can select more than one option in the validation list. does this
make sense?

 

[Jim Thomlinson]

You can not do what you are asking for with data validation. Data validation
exists in one cell so if it did allow for multiple selections where would it
put the multiple responses. It can not place the values in other cells and
one cell will only hold the one value.

 

[Gord Dibben]

It can be done using DV dropdowns and a bit of event code.

Download a sample workbook from Debra Dalgleish's site.

http://www.contextures.on.ca/excelfiles.html#DV0017


Gord Dibben MS Excel MVP