Private Sub CommandButton1_Click()
Dim F1 As Worksheet
Dim Ligne As String
Dim Cible As Variant
Set F1 = Sheets("TRACKING")
Cible = Me.TextBox1.Value
With F1
Ligne = Application.WorksheetFunction.Match(IIf(IsNumeric(Cible), CDbl(Cible), Cible), .Range("C1:C" & .Range("C" & .Rows.Count).End(xlUp).Row), 0)
If MsgBox("Etes vous sûr de vouloir sauvegarder?", vbYesNo, "confirmation") = vbYes Then
.Cells(Ligne, 13).Value = Me.TextBox4.Value
.Cells(Ligne, 14).Value = Me.TextBox5.Value
.Cells(Ligne, 12).Value = Me.ComboBox1.Value
.Cells(Ligne, 18).Value = Me.TextBox6.Value
.Cells(Ligne, 15).Value = Me.ComboBox2.Value
.Cells(Ligne, 16).Value = Me.ComboBox3.Value
.Cells(Ligne, 17).Value = Me.TextBox7.Value
.Cells(Ligne, 19).Value = Me.TextBox8.Value
.Cells(Ligne, 21).Value = Me.TextBox9.Value
.Cells(Ligne, 20).Value = Me.TextBox10.Value
.Cells(Ligne, 22).Value = Me.TextBox11.Value
.Cells(Ligne, 23).Value = Me.TextBox12.Value
End If
End With
Unload Me
End Sub