Private Sub Validez_saisie_Click()
MsgBox ("N'oubliez pas le materiel avant de Sauvegardez !!! ")
Sheets("Base").Range("J" & 2) = TxtDate3.Value
Sheets("Base").Range("D" & 7) = ComboBox5.Text
Sheets("Base").Range("D" & 9) = ComboBox6.Text
Sheets("Base").Range("D" & 23) = ComboBox7.Text
Sheets("Base").Range("E" & 23) = ComboBox8.Text
'Correspond au relever Kilometrage
Sheets("Base").Range("K" & 9) = TextBox1.Value
Sheets("Base").Range("M" & 9) = TextBox2.Value
Sheets("Base").Range("K" & 23) = TextBox3.Value
Sheets("Base").Range("M" & 23) = TextBox4.Value
'Correspond a Mr Devassine
Sheets("Base").Range("G" & 61) = ComboBox10.Value
Sheets("Base").Range("H" & 61) = ComboBox11.Value
Sheets("Base").Range("I" & 61) = ComboBox12.Value
Sheets("Base").Range("J" & 61) = ComboBox13.Value
Sheets("Base").Range("K" & 61) = ComboBox14.Value
Sheets("Base").Range("L" & 61) = ComboBox15.Value
Sheets("Base").Range("M" & 61) = ComboBox16.Value
Sheets("Base").Range("N" & 61) = ComboBox17.Value
Sheets("Base").Range("O" & 61) = ComboBox18.Value
Sheets("Base").Range("P" & 61) = ComboBox19.Value
Sheets("Base").Range("Q" & 61) = ComboBox20.Value
Sheets("Base").Range("R" & 61) = ComboBox21.Value
Sheets("Base").Range("F" & 61) = ComboBox22.Value
'Correspond a Mr Amrani A
Sheets("Base").Range("G" & 62) = ComboBox23.Value
Sheets("Base").Range("H" & 62) = ComboBox24.Value
Sheets("Base").Range("I" & 62) = ComboBox25.Value
Sheets("Base").Range("J" & 62) = ComboBox26.Value
Sheets("Base").Range("K" & 62) = ComboBox27.Value
Sheets("Base").Range("L" & 62) = ComboBox28.Value
Sheets("Base").Range("M" & 62) = ComboBox29.Value
Sheets("Base").Range("N" & 62) = ComboBox30.Value
Sheets("Base").Range("O" & 62) = ComboBox31.Value
Sheets("Base").Range("P" & 62) = ComboBox32.Value
Sheets("Base").Range("Q" & 62) = ComboBox33.Value
Sheets("Base").Range("R" & 62) = ComboBox34.Value
Sheets("Base").Range("F" & 62) = ComboBox35.Value
End Sub