Appending data in cells that utilize a Dropdown list.

  • Thread starter Thread starter Geek
  • Start date Start date
G

Geek

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?
 
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
 
Just curious on a slow day.
Why do you use the word "utilize" when use will do the same thing?
 
Back
Top