Data Validation. Multiple.
 

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

Data Validation. Multiple.
 

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

Data Validation. Multiple.
 

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

Data Validation. Multiple.
 

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

Data Validation. Multiple.
 

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