Application.CalendarDateBoxes Method (Project)

Customizes the top and bottom bands of date boxes in the Calendar view.

Syntax

expression .CalendarDateBoxes(TopLeft, TopRight, BottomLeft, BottomRight, TopColor, BottomColor, TopPattern, BottomPattern)

expression A variable that represents an Application object.

Parameters

Name

Required/Optional

Data Type

Description

TopLeft

Optional

Long

The format for dates in the upper-left corner of each date box. Can be one of the PjCalendarDateLabel constants.

TopRight

Optional

Long

The format for dates in the upper-right corner of each date box. Can be one of the PjCalendarDateLabel constants.

BottomLeft

Optional

Long

The format for dates in the lower-left corner of each date box. Can be one of the PjCalendarDateLabel constants.

BottomRight

Optional

Long

The format for dates in the lower-right corner of each date box. Can be one of the PjCalendarDateLabel constants.

TopColor

Optional

Long

The color of the top band in each date box. Can be one of the PjColor constants.

BottomColor

Optional

Long

The color of the bottom band in each date box. Can be one of the PjColor constants.

TopPattern

Optional

Long

The pattern of the top band in each date box. Can be one of the PjFillPattern constants.

BottomPattern

Optional

Long

The pattern of the bottom band in each date box. Can be one of the PjFillPattern constants.

Return Value

Boolean

Remarks

Using the CalendarDateBoxes method without specifying any arguments displays the Timescale dialog box with the Date Boxes tab selected.

To edit calendar date boxes where the colors can be RGB values, use the CalendarDateBoxesEx method.

Example

The following example displays the day of the week (for example, Thursday) in the upper-left corner, the month and date (for example, Jan 31) in the upper-right corner, the day of the year and year (for example, 70 2010) in the bottom-left corner of each date box in the calendar, and sets the background colors of the top band and the bottom band.

Sub FormatCalendarDays() 
 CalendarDateBoxes Topleft:=pjDay_dddd, TopRight:=pjDay_mmm_dd, BottomLeft:=pjCalendarLabelDayOfYear_dd_yyyy, _ 
 TopColor:=PjColor.pjSilver, BottomColor:=PjColor.pjYellow 
End Sub