Help withRetrieving Multiselect Listbox entries into different columns

[Johny1]

Hi All

I need get capture the multiselect listbox entries into different columns.

See attached example userform.

Each selection needs to be captured under the correct column heading in sheet2.

I am able capture rest of the user form inputs but also having problem in clearing the form specifically listboxes.

Any help is welcome.

Kind regard

Johny

[mehmetcik]

Hi

Look at these subroutines:

Please Login or Register  to view this content.

[Johny1]

Selam
Thanks for the pointers but I could not get head round it.
I just want to see listbox selections appearing in columns next to each other in the same row whenever the user submits the userform entries.

Tesekkurler

[protonLeah]

modify module1:

Please Login or Register  to view this content.

In Client, add

Please Login or Register  to view this content.

Modify the submit code:
add: Dim Ndx As Long

Then modify the With:

Please Login or Register  to view this content.

Modify CLEAR:

Please Login or Register  to view this content.

[Johny1]

protonLeah

Thank you very much. this resolves my problem perfectly.
Multiselection listbox would still not clear though, however I can find a solution for this.

Thanks again for your help and time.

Johny

[Norie]

You can use this to clear the selections in the listbox.

Please Login or Register  to view this content.

[Johny1]

Perfect

Once again thank you very much for your help.