Sub Dates Times Class

ZodiacSample

Signature (Visual Basic / VBA)

Private Sub ZodiacSample()
    ' Print the boundaries of the Zodiac signs.
    ' Also serves as a sample of the Zodiac function.

    Const dblMinDate = #1/1/1996#
    Const dblMaxDate = #12/31/1996#

    Debug.Print dblMinDate & " " & Zodiac(dblMinDate)

    Dim varForDate As Variant
    For varForDate = dblMinDate To dblMaxDate
        If Zodiac(varForDate) <> Zodiac(varForDate - 1) Then
            Debug.Print varForDate - 1 & " " & Zodiac(varForDate - 1)
            Debug.Print varForDate & " " & Zodiac(varForDate)
        End If
    Next varForDate

    Debug.Print dblMaxDate & " " & Zodiac(dblMaxDate)
End Sub