Data Validation. Multiple.

  • Thread starter Thread starter shapper
  • Start date Start date
S

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
 
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)
 
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.
 
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.
Click to expand...
 
Back
Top