creating drop down lists where you can select multiple values

Hi there

I want to create drop down lists in an excel spreadsheet that allow me to
select more than one value to be displayed in the cell.

Does anyone know how to help me?

Thanks in advance

You can do this with programming. There's a sample file here:

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

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


Angella wrote:
> Hi there
>
> I want to create drop down lists in an excel spreadsheet that allow me to
> select more than one value to be displayed in the cell.
>
> Does anyone know how to help me?
>
> Thanks in advance


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Angella

Check Debra Dalgleish's site for all you need to know about Data Validation
in-cell drop-downs.

http://www.contextures.on.ca/xlDataVal01.html


Gord Dibben Excel MVP

On Sat, 23 Apr 2005 08:04:06 -0700, "Angella"
<Angella@discussions.microsoft.com> wrote:

>Hi there
>
>I want to create drop down lists in an excel spreadsheet that allow me to
>select more than one value to be displayed in the cell.
>
>Does anyone know how to help me?
>
>Thanks in advance