Listbox- Is it possible to do this with listbox ?

I have Listbox on my User Form with 10 items say "A", "B","C", and so on.
I wnt User to select any one item or any two or three items or even all items. Whatever user selects will be transferred in one cell only like "a","C" .

Is it possible to do this with listbox ?

if yes please help me.

Thanks in advance for any suggestions

Hello Vandanavai,

Set the MultiSelect property of the ListBox to "fmMultiSelectExtended". Then place a CommandButton on your UserForm and copy the code below into the CommandButton's Click event procedure.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Thanks a lot Leith Ross. This is what I was looking for.