TickLabels Properties (Excel)

Office 2013

Published: July 16, 2012

This object has the following 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.

Community Additions

ADD
Show:
© 2014 Microsoft