Private Sub CommandButton1_Click()
If Not ComboBox1.Value = "" Then
Dim no_ligne As Integer
no_ligne = ComboBox1.ListIndex + 1
TextBox1.Value = Cells(no_ligne, 1).Value
TextBox3.Value = Cells(no_ligne, 3).Value
TextBox4.Value = Cells(no_ligne, 2).Value
Else
End If
End Sub