Private Sub CommandButton2_Click()
Dim i&, v$, liste
v = ""
For i = 1 To ListBox1.ListCount
v = v & vbLf & ListBox1.List(i - 1)
Next i
v = Replace(v, Chr(10), "", 1, 1)
Sheets("Feuil1").Range("H13") = v
Unload Me
End Sub
Private Sub UserForm_initialize()
ListBox1.List = Sheets("Feuil1").Range("A2:D" & Sheets("Feuil1").[A65000].End(xlUp).Row + 1).Value
End Sub