Extracting Data from Multi Selection List Boxes in Excel Userform

[CarolynS]

HI

I have a userform that contains text boxes, combo boxes, data pickers and list boxes. There are 2 list boxes, both of these are set up to allow multiple selections. I have code that loops through each control in the form to extract the data to a worksheet. This works fine for everything apart from the list boxes. The list box fields are just coming out blank. My code is below:

[    For X = 1 To 124
        nextrow = Me.Controls("NL" & X).Value
        Set nextrow = nextrow.Offset(0, 1)
    Next/CODE]

nextrow is the cell reference for the data to be copied to.

How would I amend this code to allow the data from the list boxes to be extracted?

Thanks

 

[CarolynS]

I've now found a solution but don't know how to close this thread?