TickLabels Members (Excel)

Article
05/23/2016

GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Represents the tick-mark labels associated with tick marks on a chart axis.

Methods

Name	Description
Delete	Deletes the object.
Select	Selects the object.

Properties

Name	Description
Alignment	Returns or sets a Long value that represents the alignment for the specified phonetic text or tick label.
Application	When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
Creator	Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.
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. Read-only.
MultiLevel	Sets whether an axis is multilevel or not. Read/write Boolean.
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.
NumberFormatLinked	True if the number format is linked to the cells (so that the number format changes in the labels when it changes in the cells). Read/write Boolean.
NumberFormatLocal	Returns or sets a Variant value that represents the format code for the object as a string in the language of the user.
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.
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 constants: xlRTL (right-to-left), xlLTR (left-to-right), or xlContext. Read/write Long.