Hello all,

I would like to append entries in cells that utilize a dropdown list.
Currently, when I select (in this case names) from my dropdown list I cannot
append them if I want to add more than one to a cell. If I select another
name from the dropdown, it erases the first entry. Is there some way to
append entries within cells that use this form of validation so that I can
enter more than one in a cell from the dd list?


--
Thanks,

Geek using
Office XP Professional

Hi Geek

Debra Dalgleish has an example workbook showing how to do this
http://www.contextures.com/excelfiles.html

Select Multiple Items from Dropdown List-- Select multiple items from a
dropdown list; an event macro stores selections in adjacent cell, or in the
same cell. DataValMultiSelect.xls 39kb



Cheers
JulieD

"Geek" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Hello all,
>
> I would like to append entries in cells that utilize a dropdown list.
> Currently, when I select (in this case names) from my dropdown list I
cannot
> append them if I want to add more than one to a cell. If I select another
> name from the dropdown, it erases the first entry. Is there some way to
> append entries within cells that use this form of validation so that I can
> enter more than one in a cell from the dd list?
>
>
> --
> Thanks,
>
> Geek using
> Office XP Professional
>
>

Hi Julie,

Thanks for the prompt reply! You are a lifesaver. Take care.

--
Thanks,

Geek using
Office XP Professional
"JulieD" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi Geek
>
> Debra Dalgleish has an example workbook showing how to do this
> http://www.contextures.com/excelfiles.html
>
> Select Multiple Items from Dropdown List-- Select multiple items from a
> dropdown list; an event macro stores selections in adjacent cell, or in
> the
> same cell. DataValMultiSelect.xls 39kb
>
>
>
> Cheers
> JulieD
>
> "Geek" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> Hello all,
>>
>> I would like to append entries in cells that utilize a dropdown list.
>> Currently, when I select (in this case names) from my dropdown list I
> cannot
>> append them if I want to add more than one to a cell. If I select another
>> name from the dropdown, it erases the first entry. Is there some way to
>> append entries within cells that use this form of validation so that I
>> can
>> enter more than one in a cell from the dd list?
>>
>>
>> --
>> Thanks,
>>
>> Geek using
>> Office XP Professional
>>
>>
>
>

Just curious on a slow day.
Why do you use the word "utilize" when use will do the same thing?

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"Geek" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Hello all,
>
> I would like to append entries in cells that utilize a dropdown list.
> Currently, when I select (in this case names) from my dropdown list I
cannot
> append them if I want to add more than one to a cell. If I select another
> name from the dropdown, it erases the first entry. Is there some way to
> append entries within cells that use this form of validation so that I can
> enter more than one in a cell from the dd list?
>
>
> --
> Thanks,
>
> Geek using
> Office XP Professional
>
>