Private Sub CommandButton1_Click()
For i = 0 To Me.ListBox1.ListCount - 1
If Me.ListBox1.Selected(i) Then
A = A & "," & i
End If
Next
'Worksheets("1").Range(rc) = Mid(A, 2)
Sheets(1).Cells(2, ra) = Mid(A, 2)
Range(rb) = Me.TextBox1
Unload Me
End Sub
--------------------------------------------
Dim B As Variant
B = Split(Sheets(1).Cells(2, ra), ",")
----------------------------------------------
Private Sub UserForm_Initialize()
Dim B As Variant
B = Split(Sheets(1).Cells(2, ra), ",")
Me.TextBox1 = 0
For i = 0 To UBound(B)
Me.ListBox1.ListIndex = B(i)
Me.ListBox1.Selected(B(i)) = True
Next