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

I doubt it can be done with data validation.

maybe you could use the mouse's right click or double click event to open a
userform. it would then be quite easy to multi-select from a list.

eg listbox1 has been checked...

for item = 0 to listbox1.ListCount-1
if listbox1.Selected(item) then
text = text & "," & listbox1.List(item)
end if
next
Selection = mid(text,2)






"shapper" wrote in message
...
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

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

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

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