Userforms transfering list Listbox.list's

Hi,

I've got 2 userforms. The first one appears on a commandclick. If the user clicks on a specific button on the first userfom, the second userforms is shown. The user can then proceed to chose some values from a listbox. When he clicks ok, I'd like the array which consists of the listbox.list to be transfered to the first userform.

Anyone knows how to make it work? I'm pretty sure that it aint a hard task but I lack the knowledge when it comes to userforms :/

Something like this maybe

Listboxes.xlsm

Not suprised to see a a quick response from mike7952! This seems to work. Thanks.

Last question before I mark this as solved: What changes must be done to your code, to make listbox values get transfered to a textbox instead listbox?

Please Login or Register  to view this content.

doesn't seem to do it ..

Something like this maybe.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Doesn't seem to do the trick - Could not get the List property. Invalid property array index.

This works for me

Listboxes_v2.xlsm

I don't know what I have done wrong previously but now it seems to be working. The downside of your code seems to be the fact, that it only moves the last value. Thanks a lot for your time. If you can come up with how to transfer all the values from the listbox then I'd sacrifice a goat in your name!

testmike.xlsm

If your textbox is set to multiline then try this

Please Login or Register  to view this content.

Set the Textbox Multiline property to True an use this

Please Login or Register  to view this content.

works like a charm. Muchos Gracias! :}

@Bishonen, checked, rechecked the tube and .... nothing. the clock is ticking.