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" <(E-Mail Removed)> wrote in message
news:851c6043-fff2-4551-b67d-(E-Mail Removed)...
> 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 <(E-Mail Removed)> 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
news(E-Mail Removed)...
> 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 <(E-Mail Removed)>
> 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"
<(E-Mail Removed)> 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
>news(E-Mail Removed)...
>> 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 <(E-Mail Removed)>
>> 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
>>