Private Sub DDate_Exit(ByVal Cancel As MSForms.ReturnBoolean)
Dim trouve as Boolean
for each cel in Range("CONTROL")
If Mid(DDate.Text, 4, 4) = [B]cel [/B]Then trouve=true
next cel
If trouve=False then MsgBox "le format est incorrect.": Exit Sub
End Sub