Dim date1
Dim date2
Dim date3
Dim date4
Dim date5
Dim date6
On Error Resume Next
date1 = Format(TextBox14.Value, "dd/mm/yyyy")
date1 = CDate(date1)
date2 = Format(TextBox16.Value, "dd/mm/yyyy")
date2 = CDate(date2)
date3 = Format(TextBox17.Value, "dd/mm/yyyy")
date3 = CDate(date3)
date4 = Format(TextBox15.Value, "dd/mm/yyyy")
date4 = CDate(date4)
date5 = Format(TextBox6.Value, "dd/mm/yyyy")
date5 = CDate(date5)
date6 = Format(TextBox7.Value, "dd/mm/yyyy")
date6 = CDate(date6)
On Error Goto 0
Worksheets("fiche").Range("c12") = date1