Format related procedures in class TickLabels (Word VBA)

This page presents procedures from class TickLabels related to the theme Format: Font, Format and NumberFormat


Returns the font of the specified object.

Dim cftFont As ChartFont
Set cftFont = ActiveDocument.Background.Chart.Axes(1).TickLabels.Font


Returns the line, fill, and effect formatting for the object.

Dim cftFormatted As ChartFormat
Set cftFormatted = ActiveDocument.Background.Chart.Axes(1).TickLabels.Format


Returns or sets the format code for the object.

The format code is the same string as the Format Codes option in the Format Cells dialog box. The Format function uses different format code strings than do the NumberFormat and NumberFormatLocal properties.

ActiveDocument.Background.Chart.Axes(1).TickLabels.NumberFormat =