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
| Function EstFerie(ByVal QuelleDate As Date) As Boolean
Dim anneeDate As Integer
Dim joursFeries(1 To 8) As Date
Dim I As Integer
Dim jourouvré As Date
anneeDate = Year(QuelleDate)
joursFeries(1) = DateSerial(anneeDate, 1, 1)
joursFeries(2) = DateSerial(anneeDate, 5, 1)
joursFeries(3) = DateSerial(anneeDate, 5, 8)
joursFeries(4) = DateSerial(anneeDate, 7, 14)
joursFeries(5) = DateSerial(anneeDate, 8, 15)
joursFeries(6) = DateSerial(anneeDate, 11, 1)
joursFeries(7) = DateSerial(anneeDate, 11, 11)
joursFeries(8) = DateSerial(anneeDate, 12, 25)
For I = 1 To 8
' MsgBox (joursFeries(I))
Next
End Function
Private Sub Calendar0_Updated(Code As Integer)
If Calendar0.Value = joursFeries(I) Or Calendar0.Value = vbSunday Or Calendar0.Value = vbSaturday Then
Calendar0.Visible = False
Else
Calendar0.Visible = True
End If
End Sub |
Partager