VBA Learning Note (-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 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)