@ 3GB
Je viens de faire la modif sauf que j'ai deux soucis dans le code, j'ai essayé de modifier en fonction de mes connaissances mais sans succès car je n'ai jamais fait ce genre de codage dans un Module.
Sub Actualisation()
Dim L As Integer, TDon(), m As Integer, j As Integer, Lab As MSForms.Label, TBx As MSForms.TextBox, I As Integer
TDon = Feuil3.[A5].Resize(366, 2).Value
For L = 1 To DateSerial(Year(TDon(1, 1)) + 1, 1, 1) - TDon(1, 1)
m = Month(TDon(L, 1)): j = Day(TDon(L, 1))
Set Lab = Me("Label" & L)
Set TBx = Me("TextBox" & L)
Lab.Caption = Application.Proper(Format(TDon(L, 1), "ddd d"))
Lab.ForeColor = IIf(EstFérié(TDon(L, 1)), &HC0, vbBlack) Or IIf(Weekday(TDon(L, 1), vbMonday) = 7, vbRed, vbBlack)
Lab.BackColor = IIf(EstFérié(TDon(L, 1)), &H66FF66, &HE3FFC8)
Lab.Font.Bold = EstFérié(TDon(L, 1))
Lab.Font.Underline = IIf(Weekday(TDon(L, 1), vbMonday) = 7, True, False)
TBx.Text = TDon(L, 2)
Lab.Left = 18 + (m - 1) * 84: Lab.Width = 36: Lab.Top = 40.5 + (j - 1) * 18: Lab.Height = 15
TBx.Left = 55 + (m - 1) * 84: TBx.Width = 29: TBx.Top = 40.5 + (j - 1) * 18: TBx.Height = 15
Select Case TDon(L, 2)
Case "M": TBx.BackColor = RGB(242, 8, 132)
Case "S": TBx.BackColor = RGB(0, 204, 255)
Case "N": TBx.BackColor = RGB(31, 183, 20)
Case "J": TBx.BackColor = RGB(255, 215, 45)
Case "REM": TBx.BackColor = RGB(240, 255, 45)
Case "CP": TBx.BackColor = RGB(255, 153, 0) 'ou 255,102,0
Case "CPN": TBx.BackColor = RGB(255, 153, 0) 'ou 255,102,0
Case "CA": TBx.BackColor = RGB(0, 235, 153) 'ou 204, 255, 204
Case "CAN": TBx.BackColor = RGB(0, 235, 153) 'ou 204, 255, 204
Case "EF": TBx.BackColor = RGB(255, 153, 204)
Case "EFN": TBx.BackColor = RGB(255, 153, 204)
Case "AM": TBx.BackColor = RGB(255, 0, 0)
TBx.ForeColor = &HFFFFFF: TBx.Font.Bold = True
Case "JCN": TBx.BackColor = RGB(153, 204, 0)
Case "HAR": TBx.BackColor = RGB(204, 204, 255)
Case "RSU": TBx.BackColor = RGB(255, 204, 153)
Case "REC": TBx.BackColor = RGB(255, 255, 255)
Case "GRV": TBx.BackColor = RGB(153, 102, 51)
TBx.ForeColor = &HFFFFFF: TBx.Font.Bold = True
Case "FOS": TBx.BackColor = RGB(164, 82, 0)
TBx.ForeColor = &HFFFFFF: TBx.Font.Bold = True
Case "FOSN": TBx.BackColor = RGB(164, 82, 0)
TBx.ForeColor = &HFFFFFF: TBx.Font.Bold = True
Case "DEL": TBx.BackColor = RGB(164, 82, 0)
TBx.ForeColor = &HFFFFFF: TBx.Font.Bold = True
Case "DELN": TBx.BackColor = RGB(164, 82, 0)
TBx.ForeColor = &HFFFFFF: TBx.Font.Bold = True
Case "ACTP": TBx.BackColor = RGB(0, 0, 0)
TBx.ForeColor = &HFFFFFF: TBx.Font.Bold = True
Case "AAN": TBx.BackColor = RGB(166, 166, 166)
TBx.ForeColor = &HFFFFFF: TBx.Font.Bold = True
End Select
Next L
Label366.Visible = L > 366: TextBox366.Visible = L > 366
End Sub