Data Validation. Multiple.

[shapper]

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

 

[Patrick Molloy]

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)

 

[Gord Dibben]

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

 

[Patrick Molloy]

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]

Debra does nice work.


Gord

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.