Class TickLabels (Excel 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

Themes

The following procedures in this class have been grouped together and are described on a separate theme page

Number with its procedures NumberFormatLinked and NumberFormatLocal

Methods

These are the main methods of the TickLabels class

Delete - Deletes the object.

Select - Selects the object.

Properties

Alignment returns or sets a Long value that represents the alignment for the specified phonetic text or tick label.

Depth returns a Long value that represents the number of levels of category tick labels.

Font returns a Font object that represents the font of the specified object.

Format returns the ChartFormat object.

MultiLevel sets whether an axis is multilevel.

Name returns a String value that represents the name of the object.

NumberFormat returns or sets a String value that represents the format code for the object.

Offset returns or sets a Long value that represents the distance between the levels of labels, and the distance between the first level and the axis line.

With Charts("Chart1").Axes(xlCategory).TickLabels 
 If .Offset < 500 then 
 .Offset = .Offset * 2 
 End If 
End With

Orientation returns or sets a Long value that represents the text orientation.

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

ReadingOrder returns or sets the reading order for the specified object. Can be one of the following XlReadingOrder constants: xlRTL (right-to-left), xlLTR (left-to-right), or xlContext.