Showing posts with label Excel VBA. Show all posts
Showing posts with label Excel VBA. Show all posts

Action Object

Action Method

E

Action Property

A C N P T

Action Property TOC - T

Type

Returns the action type. Read-only XlActionType.

See Type

Action Property TOC - P

Parent

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

See Parent

Action Property TOC - N

Name

Returns the name of the object. Read-only String.

See Name

Action Property TOC - C

Caption

Returns the caption assigned to the Action object. Read-only String.

See Caption

Content

Returns the content associated to the Action object. Read-only String.

See Content

Coordinate

Returns the coordinate property of the Action object. Read-only

See Coordinate

Creator

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

See Creator

Action Property TOC - A

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.

See Application

Action Method TOC - E

Execute

Performs the specified action.

See Execute

Action Execute Method

Purpose

Performs the specified action.

Syntax

Execute

Action Type Property

Purpose

Returns the action type. Read-only XlActionType.

Syntax

Type

Action Parent Property

Purpose

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

Syntax

Parent

Action Name Property

Purpose

Returns the name of the object. Read-only String.

Syntax

Name

Action Creator Property

Purpose

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

Syntax

Creator

Action Coordinate Property

Purpose

Returns the coordinate property of the Action object. Read-only

Syntax

Coordinate

Action Content Property

Purpose

Returns the content associated to the Action object. Read-only String.

Syntax

Content

Action Caption Property

Purpose

Returns the caption assigned to the Action object. Read-only String.

Syntax

Caption

Action Application Property

Purpose

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.

Syntax

Application

AboveAverage Object

AboveAverage Method

D M S

AboveAverage Property

A B C F I N P S T

AboveAverage Property TOC - T

Type

Returns one of the constants of the XlFormatConditionType enumeration, which specifies the type of conditional format. Read-only.

See Type

AboveAverage Property TOC - S

ScopeType

Returns or sets one of the constants of the XlPivotConditionScope enumeration, which determines the scope of the conditional format when it is applied to a PivotTable.

See ScopeType

StopIfTrue

Returns or sets a Boolean value that determines if additional formatting rules on the cell should be evaluated if the current rule evaluates to True.

See StopIfTrue

AboveAverage Property TOC - P

Parent

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

See Parent

Priority

Returns or sets the priority value of the conditional formatting rule. The priority determines the order of evaluation when multiple conditional formatting rules exist in a worksheet.

See Priority

PTCondition

Returns a Boolean value indicating if the conditional format is being applied to a PivotTable. Read-only.

See PTCondition