VBA Learning Note (-cell Object members)

Source: Internet
Author: User

Cell Object Members

Holds a formula that evaluates to some value.

Methods

Name

Description

GlueTo

Glues one shape to another, from a cell in the first shape to a cell in the second shape.

GlueToPos

Glues one shape to another from a cell in the first shape to an X, Y position in the second shape.

Trigger

Evaluates the formula of a cell.

Properties

Name

Description

Application

Read-only. Returns the instance of Microsoft Office Visio are associated with an object.

Column

Returns the column index of a cell. Read-only.

Containingmasterid

Returns the ID of the Master object that is contains an object. Read-only.

ContainingPageID

Returns the ID of the page that is contains an object. Read-only

Containingrow

Returns The row that contains a cell. Read-only.

Dependents

Returns an array of ShapeSheet cells is dependent on a particular cell of a Microsoft Office Visio shape. Read-only.

Document

Gets the Document object, which is a associated with an object. Read-only.

Error

Gets the error code generated by the last evaluation of a cell ' s formula. Read-only.

EventList

Returns the EventList collection of an object or the EventList collection this contains an Event object. Read-only.

Formula

Gets or sets the formula for a Cell object. Read/write.

FormulaForce

Sets the formula in a Cell object, even if the formula are protected with a GUARD function. Read/write.

Formulaforceu

Sets the universal syntax formula in a Cell object, even if the formula are protected with a GUARD function. Read/write.

FormulaU

Gets or sets the universal syntax formula for a Cell object. Read/write.

InheritedFormulaSource

Returns the cell from which this cell inherited its formula. Read-only.

InheritedValueSource

Returns the cell from which this cell inherited its value. Read-only.

IsConstant

Determines whether a formula of the cell is a constant expression. Read-only.

isinherited

Determines whether a formula of the cell is inherited from a master or a style. Read-only.

LocalName

Returns The local name of a cell. Read-only.

Name

Specifies the name of an object. Read-only.

ObjectType

Returns An object ' s type. Read-only.

PersistsEvents

Indicates whether an object was capable of containing persistent events in its EventList collection. Read-only.

Precedents

Returns an array of ShapeSheet cells upon which the formula of another cell depends. Read-only.

Result

Gets or sets a cell ' s value. Read/write.

ResultForce

Sets a cell ' s value, even if the cell ' s formula is protected with the GUARD function. Read/write.

ResultFromInt

Sets the value of a cell to an integer value. Read/write.

ResultFromIntForce

Sets the value of a cell to an integer value, even if the cell's formula is protected with the GUARD function. Read/write.

ResultInt

Gets the value of a cell expressed as an integer. Read-only.

ResultIU

Gets or sets a cell ' s value in internal units. Read/write.

ResultIUForce

Sets a cell ' s value in internal units, even if the cell's formula is protected with the GUARD function. Read/write.

ResultStr

Gets the value of a ShapeSheet cell expressed as a string. Read-only.

ResultStrU

Gets the value of a ShapeSheet cell expressed as a universal string. Read-only.

Row

Returns the row index of a cell. Read-only.

RowName

Gets or sets the name of the row that contains the Cell object. Read/write.

RowNameU

Gets or sets the universal name of the row that contains the Cell object. Read/write.

Section

Returns the index of the cell ' s section. Read-only.

Shape

Returns the Shape object that owns a Cell, characters, Row, or section object or that's associated with a Hyperlink or OL Eobject object or with the Hyperlinks collection. Read-only.

Stat

Returns status information for a object. Read-only.

Style

Gets The style that contains a Cell object. Read-only.

Units

Indicates the unit of measure associated with a Cell object. Read-only.

Events

Name

Description

CellChanged

Occurs after the value changes in a cell in a document.

FormulaChanged

Occurs after a formula changes in a cell with the object that receives the event.

VBA Learning Note (-cell Object members)

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.