Table of contents
TOC
Collapse the table of content
Expand the table of content

Application.CalendarDateBoxesEx Method (Project)

office 365 dev account|Last Updated: 6/12/2017
|
1 Contributor

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

Syntax

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

expression An expression that returns an Application object.

Parameters

NameRequired/OptionalData TypeDescription
TopLeftOptionalLongThe format for dates in the upper-left corner of each date box. Can be one of the PjCalendarDateLabel constants.
TopRightOptionalLongThe format for dates in the upper-right corner of each date box. Can be one of the PjCalendarDateLabel constants.
BottomLeftOptionalLongThe format for dates in the lower-left corner of each date box. Can be one of the PjCalendarDateLabel constants.
BottomRightOptionalLongThe format for dates in the lower-right corner of each date box. Can be one of the PjCalendarDateLabel constants.
TopColorOptionalLongThe color of the top band in each date box. Can be a hexadecimal value for the RGB color, where red is the last byte. For example, the value &;HFF0000 is blue and &;H00FFFF is yellow.
BottomColorOptionalLongThe color of the bottom band in each date box. Can be a hexadecimal value for the RGB color.
TopPatternOptionalLongThe pattern of the top band in each date box. Can be one of the PjFillPattern constants.
BottomPatternOptionalLongThe pattern of the bottom band in each date box. Can be one of the PjFillPattern constants.

Return Value

Boolean

Remarks

Using the CalendarDateBoxesEx 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, 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 color of the top band to silver and the background color of the bottom band to a light yellow.

Sub FormatCalendarDays() 
      CalendarDateBoxesEx Topleft:=pjOverflowIndicator, TopRight:=pjDay_mmm_dd, _ 
        BottomLeft:=pjCalendarLabelDayOfYear_dd_yyyy, _ 
        TopColor:=&;HE0E8E8, BottomColor:=&;H1E8E8 
End Sub

Note If you use any of the PjColor enumeration constants for the TopColor or BottomColor parameters, the color will be nearly black. For example, the value of pjGreen is 9, which in the CalendarDateBoxesEx method is a very dark red. To use only the sixteen colors available with PjColor constants, use the CalendarDateBoxes method.

© 2018 Microsoft