Private Sub ComboBox1_Change()
Dim no_ligne As Integer
no_ligne = ComboBox1.ListIndex + 1
If ComboBox1.ListIndex = -1 Then
TextBox2.Value = ""
TextBox3.Value = ""
TextBox4.Value = ""
TextBox6.Value = ""
Exit Sub
End If
TextBox2.Value = Sheets("Clients").Cells(no_ligne, 3).Value
TextBox3.Value = Sheets("Clients").Cells(no_ligne, 4).Value
TextBox4.Value = Sheets("Clients").Cells(no_ligne, 2).Value
TextBox6.Value = Sheets("Clients").Cells(no_ligne, 5).Value
TextBox6.Visible = False
End Sub