X = DateAMJ(TextBox10, TextBox9, TextBox8) ' compile la date
Ensuite quand on appuis sur F8
Function DateAMJ(ByVal xa, ByVal xm, ByVal xj) As Variant
'retourne la date ou une erreur
Const MoisA = "janv,févr,mars,avr,mai,juin,juil,août,sept,oct,nov,déc"
Dim an, Nbr As Boolean
DateAMJ = CVErr(xlErrNA)
On Error Resume Next
If xa = "" Or xm = "" Or xj = "" Then Exit Function
Nbr = ((xa Like "#") Or (xa Like "##") Or (xa Like "####"))
Nbr = Nbr And ((xm Like "#") Or (xm Like "##")) And ((xj Like "#") Or (xj Like "##"))
If Not Nbr Then Exit Function
an = Int(Val(xa))
If an < 0 Then
Exit Function
ElseIf an < 100 Then
an = 2000 + an
ElseIf an < 1900 Then
Exit Function
End If
DateAMJ = CDate(Join(Array(xj, Split(MoisA, ",")(CInt(xm) - 1), an)))
End Function