Class TickLabels (PowerPoint VBA)

The class TickLabels represents the tick-mark labels associated with tick marks on a chart axis.

The main procedures of class TickLabels are Delete and Select


To use a TickLabels class variable it first needs to be instantiated, for example

Dim tls as TickLabels
Set tls = ActiveWindow.RangeFromPoint.Chart.Axes(1).TickLabels

The following procedures can be used to set variables of type TickLabels: Axis.TickLabels and ChartGroup.RadarAxisLabels


Some procedures in this class have been grouped together in themes and are described on separate theme pages

Format with its procedures Font and Format
Number with its procedures NumberFormat, NumberFormatLinked and NumberFormatLocal


These are the main methods of the TickLabels class

Delete - Deletes the object.


Select - Selects the object.



Alignment returns or sets the alignment for the specified phonetic text or tick label.

ActiveWindow.RangeFromPoint.Chart.Axes(1).TickLabels.Alignment =

Depth returns the number of levels of category tick labels.

Dim lngDepth As Long
lngDepth = ActiveWindow.RangeFromPoint.Chart.Axes(1).TickLabels.Depth

MultiLevel returns or sets a value that indicates whether an axis is multilevel.

ActiveWindow.RangeFromPoint.Chart.Axes(1).TickLabels.MultiLevel = True

Name returns the name of the object.

Dim strName As String
strName = ActiveWindow.RangeFromPoint.Chart.Axes(1).TickLabels.Name

Offset returns or sets the distance between the levels of labels, and the distance between the first level and the axis line.

ActivePresentation.Slides(1).Shapes(1).Chart.Axes(1).TickLabels.Offset = 2

Orientation returns or sets the text orientation.

ActiveWindow.RangeFromPoint.Chart.Axes(1).TickLabels.Orientation = xlTickLabelOrientationAutomatic

Parent returns the parent for the specified object. Read-only object.

Dim objParent As Object
Set objParent = ActiveWindow.RangeFromPoint.Chart.Axes(1).TickLabels.Parent

ReadingOrder returns or sets an XlReadingOrder constant that represents the reading order for the specified object.

ActiveWindow.RangeFromPoint.Chart.Axes(1).TickLabels.ReadingOrder =