Pull all values from UserForm List Box and Paste them to Dynamic Array in Worksheet

Hi all,

Lost again.

I have two List Boxes, LstBx_ColorsAvailable and LstBx_ColorsSelected. The user adds values from ColorsAvailable to ColorsSelected. The Add Flower button then finds the first available column and set the values in

Row 1 = TxtBx_LatinName
Row 2 = TxtBx_Common Name
Rows 3 to Row n = all values in LstBx_ColorsSelected where n is the count of all values in the list box

The first two operation for LatinName and CommonName are working but I'm lost on how to add the values from the list box to the sheet.

Please Login or Register  to view this content.

My initial post for this project can be found at:

HTML Code: 

Thank you for the help.

Since you have added the values to the listbox "LstBx_ColorsSelected", and want them all, then you could replace this section of code:

Please Login or Register  to view this content.

with code like

Please Login or Register  to view this content.

You're welcome - I'm happy that I was able to help