Dim i As Byte
Private Sub UserForm_Initialize()
ComboBox1.List = Feuil1.Range("a2:d" & Feuil1.Cells(Rows.Count, 1).End(3).Row).Value
End Sub
Private Sub ComboBox1_Change()
For i = 1 To 4: Me("TextBox" & i) = ComboBox1.List(ComboBox1.ListIndex, i - 1): Next i
End Sub