If moiatbrut = "jan" Then
moiat = 1
ElseIf moiatbrut = "fev" Then
moiat = 2
ElseIf moiatbrut = "mar" Then
moiat = 3
ElseIf moiatbrut = "avr" Then
moiat = 4
ElseIf moiatbrut = "mai" Then
moiat = 5
ElseIf moiatbrut = "jun" Then
moiat = 6
ElseIf moiatbrut = "jui" Then
moiat = 7
ElseIf moiatbrut = "aoû" Then
moiat = 8
ElseIf moiatbrut = "sep" Then
moiat = 9
ElseIf moiatbrut = "oct" Then
moiat = 10
ElseIf moiatbrut = "nov" Then
moiat = 11
ElseIf moiatbrut = "dec" Then
moiat = 12
End If
Sub Cathy_Date()
Dim Tst$
Tst = "Janv"
MsgBox Format(DateValue("01 " & Tst & " 2000"), "m")
End Sub
Sub TableauFixe()
Dim Mois(12) As String
Dim i As Integer
dataccess = [D4]
Mois(1) = "jan": Mois(2) = "fev": Mois(3) = "mar": Mois(4) = "avr": Mois(5) = "mai": Mois(6) = "jun": Mois(7) = "jui": Mois(8) = "aoû": Mois(9) = "sep": Mois(10) = "oct": Mois(11) = "nov": Mois(12) = "dec"
'Boucle sur les éléments du tableau pour lire leur contenu
For i = 1 To 12
If Mois(i) = dataccess Then
moiat = i
MsgBox moiat
Exit For
End If
Next i
End Sub
Sub Cathy_Date_2()
Dim D As Object, Tst$
Set D = CreateObject("Scripting.dictionary")
D("jan") = 1: D("fev") = 2: D("mar") = 3
D("avr") = 4: D("mai") = 5: D("jun") = 6
D("jui") = 7: D("aoû") = 8: D("sep") = 9
D("oct") = 10: D("nov") = 11: D("dec") = 12
Tst = "dec"
MsgBox D(Tst)
End Sub
Function LeMoisLettres(iMois As Integer)
If iMois > 0 And iMois < 13 Then
LeMoisLettres = Array("jan", "fév", "mar", "avr", "mai", "juin", "juil", "août", "sept", "oct", "nov", "déc")(iMois-1)
Else
LeMoisLettres = CVErr(xlErrValue)
End If
End Function