Private Sub ComboBox1_Change()
Dim Ligne As Long
Dim I As Integer
Set ws = Sheets("fEUIL1")
If Me.ComboBox1.ListIndex = -1 Then Exit Sub
Ligne = Me.ComboBox1.ListIndex + 2
ComboBox2 = ws.Cells(Ligne, "B")
For I = 1 To 7
Me.Controls("TextBox" & I) = ws.Cells(Ligne, I + 2)
Next I
End Sub