Data Validation. Multiple.

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
 
P

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)
 
P

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.
 
G

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top