Need help with populating Listbox from another Listbox(selection); across userforms.

[SoulPrisoner]

Hello everyone,

this is my first post on this forum. I came here to search the guidance cause even though uncle google is pretty strong tool he is not boundless. I´ve always managed to find what I needed up till now, spent a LOT o´time searching and just couldnt hit the spot. So I´ve registered and writing these lines kind of a last instance where to find the solution.

Ok enough of the background story, back to the business. Here is my issue I´ve failed to solve:

I have a listbox filled with variable range (converted from header to fit the list order) with multiselect property and I need to take all the selected values by the user and populate them to another listbox in another userform - all is working apart from the data transfort within the userforms.

I can export data to worksheet and then upload em to the correct lbx OR I´m also able to make it within the one userform (even with the look of that the userform has actualy changed) but that is not what i want. I know it might sound a bit freaky of me, to have one solution on which to dwell but thats who I´m i need the cleanest and most perfect way (at least to my knowledge and in my eyes) possible and therefore any workaround is not good enough for me...:-(

any ideas how to address this issue? I´ve tried to make the selected range as a variable value and use it with the additem method which proved to be flawed in this scenario, have tried many other stuff but all attempts just failed.

Hope there will be someone to know what to do or else it will bug me to the ground...:-(

Best regards

Soul

[Kyle123]

Can you post the code you have so far please?

[SoulPrisoner]

Ofc i can, not sure it helps since the issue I´ve described seems as a stand alone thing but here it goes

Please Login or Register  to view this content.

if i use msgbox for the "text" value it shows the list precisely as i want to input it to the next userform´s listbox but i just cant get it there

EDIT: this code is all working btw. all my attempts are not there (and they are nowhere to be found since if it doesnt work and i dunno how to make it work i delete it)

[Kyle123]

maybe:

Please Login or Register  to view this content.

[SoulPrisoner]

lol...so easy...and i would bet my pants i´ve tried that one aswell, well prolly not!

(its kinda same solution as if you´re populating the second lbx within the same useform funny)

well, THX a lot, it works as intended and its absolutely marvelous, I knew i´ll get the helping hand here.

Best regards

Soul

[Kyle123]

No problem, glad it helped