1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44
|
Private Sub Document_ContentControlOnExit(ByVal cc1 As ContentControl, Cancel As Boolean)
Dim i As Integer
Dim maDate As Date
Dim strDate
Dim tbJour() As String
'Si controle Date et si contenu saisi dans le controle
If cc1.Type = wdContentControlDate Then
'Test si saisie par utilisateur
If cc1.Range <> cc1.PlaceholderText Then
strDate = cc1.Range
'Suppression du jour texté
tbJour() = Split(UCase("Lundi,Mardi,Mercredi,Jeudi,Vendredi,Samedi,Dimanche," & _
"Lun,Mar,Mer,Jeu,Ven,Sam,Dim," & _
"Monday,Tuesday,Wednesday,Thursday,Friday,Saturday,Sunday," & _
"Mon,Tue,Wed,Thu,Fri,Sat,Sun,"), ",")
For i = 0 To UBound(tbJour)
strDate = Replace(UCase(strDate), UCase(tbJour(i)), " ")
Next i
'Remplacement des caractères superflus
strDate = Replace(strDate, ",", " ")
strDate = Replace(strDate, "/", " ")
strDate = Replace(strDate, ".", " ")
On Error GoTo DateErr_
maDate = DateValue(strDate)
MsgBox maDate
Exit Sub
Else
'MsgBox "Aucune date saisie, control ""vide"""
End If
End If
Exit Sub
DateErr_:
MsgBox strDate & " n'est pas une date, veuillez saisir à nouveau"
end sub |
Partager