Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("Ma_date")) Is Nothing And VarType(Target.Value) = vbDate Then
Call CLICK_INFOS_OPOC
End If
If Not Intersect(Target, Range("Ma_date")) Is Nothing And VarType(Target.Value) <> vbDate Then
MsgBox "Entrez la date en format jj/mm/aaaa"
End If
End Sub