首页 > 代码库 > VBA学习笔记(10)-Cell Object Members
VBA学习笔记(10)-Cell Object Members
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 that is associated with an object. | |
Column | Returns the column index of a cell. Read-only. | |
ContainingMasterID | Returns the ID of the Master object that contains an object. Read-only. | |
ContainingPageID | Returns the ID of the page that contains an object. Read-only | |
ContainingRow | Returns the row that contains a cell. Read-only. | |
Dependents | Returns an array of ShapeSheet cells that are dependent on a particular cell of a Microsoft Office Visio shape. Read-only. | |
Document | Gets the Document object that is 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 that 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 is protected with a GUARD function. Read/write. | |
FormulaForceU | Sets the universal syntax formula in a Cell object, even if the formula is 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 is 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 is associated with a Hyperlink or OLEObject object or with the Hyperlinks collection. Read-only. | |
Stat | Returns status information for an 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 in the object that receives the event. |
VBA学习笔记(10)-Cell Object Members