Class CellFormat (Excel VBA)

The class CellFormat represents the search criteria for the cell format.

Class Application gives access to class CellFormat.

Member in collection

Item

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

Dim cft as CellFormat
Set cft = Application.FindFormat

The following procedures can be used to set variables of type CellFormat: Application.FindFormat and Application.ReplaceFormat.

Clear - Clears the criteria set in the FindFormat and ReplaceFormat properties.

Properties

AddIndent returns or sets a value that indicates if text is automatically indented when the text alignment in a cell is set to equal distribution (either horizontally or vertically).

Borders

Font

FormulaHidden returns or sets a value that indicates if the formula will be hidden when the worksheet is protected.

HorizontalAlignment returns or sets a value that represents the horizontal alignment for the specified object.

IndentLevel returns or sets a value that represents the indent level for the cell or range. Can be an integer from 0 to 15.

Interior

Locked returns or sets a Variant value that indicates if the boolean is locked.

MergeCells true if the range or style contains merged cells.

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

NumberFormatLocal returns or sets a value that represents the format code for the object as a string in the language of the user.

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

ShrinkToFit returns or sets a value that indicates if text automatically shrinks to fit in the available column width.

VerticalAlignment returns or sets a value that represents the vertical alignment of the specified object.

WrapText returns or sets a Variant value that indicates if Microsoft Excel wraps the text in the string.

Borders - A collection of four Border objects that represent the four borders of a Range object or Style object.

Font - Contains the font attributes (font name, font size, color, and so on) for an object.

Interior - Represents the interior of an object.