DisplayFormat Members (Excel)

GitHub-Mark-64px

Contribute to this content

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

Represents the display settings for an associated Range object. Read only.

Name

Description

AddIndent

Returns a value that indicates if Microsoft Excel automatically indents text of the associated Range object when the text alignment in a cell is set to equal distribution (either horizontally or vertically), as it is displayed in the current user interface. Read-only.

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. Read-only.

Borders

Returns a Borders object that represents the borders of the associated Range object as it is displayed in the current user interface. Read-only.

Characters

Returns a Characters object that represents a range of characters within the text of the associated Range object as it is displayed in the current user interface. Read-only.

Creator

Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.

Font

Returns a Font object that represents the font of the associated Range as it is displayed in the current user interface. Read-only.

FormulaHidden

Returns a value that indicates if the formula of the associated Range object is hidden when the worksheet is protected as it is displayed in the current user interface. Read-only.

HorizontalAlignment

Returns a value that represents the horizontal alignment of the associated Range object as it is displayed in the current user interface. Read-only.

IndentLevel

Returns a value that represents the indent level of the associated Range object as it is displayed in the current user interface. Read-only.

Interior

Returns an Interior object that represents the interior of the associated Range object as it is displayed in the current user interface. Read-only.

Locked

Returns a value that indicates if the associated Range object is locked as it is displayed in the current user interface. Read-only.

MergeCells

Returns a value that indicates if the associated Range object contains merged cells as it is displayed in the current user interface. Read-only.

NumberFormat

Returns a value that represents the format code of the associated Range object as it is displayed in the current user interface. Read-only.

NumberFormatLocal

Returns a value that represents the format code of the associated Range as a string in the language of the user as it is displayed in the current user interface. Read-only.

Orientation

Returns a value that represents the text orientation of the associated Range object as it is displayed in the current user interface. Read-only.

Parent

Returns the parent object for the specified object. Read-only.

ReadingOrder

Returns the reading order of the associated Range object as it is displayed in the current user interface. Read-only.

ShrinkToFit

Returns a value that indicates if Microsoft Excel automatically shrinks text to fit in the available column width of the associated Range object as it is displayed in the current user interface. Read-only.

Style

Returns a value, containing a Style object, that represents the style of the associated Range object as it is displayed in the current user interface.

VerticalAlignment

Returns a value that represents the vertical alignment of the associated Range object as it is displayed in the current user interface. Read-only.

WrapText

Returns a value that indicates if Microsoft Excel wraps the text of the associated Range object as it is displayed in the current user interface. Read-only.

Show: