Debra does nice work.


Gord

On Thu, 26 Nov 2009 19:00:23 -0000, "Patrick Molloy"
wrote:

nice! She's saving the selected value, UNDO'ing the entry to retrieve the
original value and concatenating the new value to that. very good.



"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
See Debra Dalgleish's site for a downloadable sample workbook with event
code to get multiple selections from a DV dropdown.

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

Note that you can have the selections in an adjacent cell or in the same
cell.


Gord Dibben MS Excel MVP

On Thu, 26 Nov 2009 07:31:28 -0800 (PST), shapper
wrote:

Hello,

I am using data validation on a cell that creates a option list from a
lookup table (range of cells).

Is there a way when I go to the cell to select multiple options and
those options are added to the cell as a CSV list?

Thanks,
Miguel