Private Sub Tdate_Exit(ByVal Cancel As MSForms.ReturnBoolean)
Dim an As Integer
If TDate = Format(TDate, "dd/mm/yyyy") Then
an = Year(CDate(TDate))
Else
MsgBox "Le format de date n'est pas correct", vbCritical, Me.Caption
Exit Sub
End If
If TDate <> "" And an < 2012 Then
Cancel = True
MsgBox "Entrez une date valide à partir de l'année 2012"
TDate = ""
End If
End Sub