drop down lists

[Katherine]

to add to my last question - and is it possible to choose
more than one from the list to go into the box?

Thank you

Katherine

 

[Nick Hodge]

Katherine (Sorry I spelt it wrong last time)

You can only have one selection from a data validation list, if that's what
you mean

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]

 

[Debra Dalgleish]

You can use programming to allow multiple selections. There's a sample
file here:

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

Under 'Data Validation', look for
'Select Multiple Items from Dropdown List'