通过

Application.CalendarDateBoxes Method

  • 项目
Project Developer Reference

Customizes the date boxes in the Calendar.

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.

Example
The following example displays the day of the week (for example, Thursday) in the upper-left corner of the calendar date boxes and the month and date (for example, Jan 31) in the upper-right corner of the calendar date boxes.

Visual Basic for Applications 
  Sub FormatCalendarDays()
    CalendarDateBoxes Topleft:=pjDay_dddd, TopRight:=pjDay_mmm_dd
End Sub

See Also