Muokkaa

Jaa


Cell.ResultForce property (Visio)

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

Syntax

expression.ResultForce (UnitsNameOrCode)

expression A variable that represents a Cell object.

Parameters

Name Required/Optional Data type Description
UnitsNameOrCode Required Variant The units to use when setting the cell's value.

Return value

Double

Remarks

Use the ResultForce method to set a cell's value even if the cell's formula is protected with a GUARD function. If the string is invalid, an error is generated.

Setting the ResultForce property is similar to setting a cell's ResultFromIntForce property. The difference is that the ResultFromIntForce property accepts an integer for the value of the cell, whereas the ResultForce property accepts a floating point number.

You can specify UnitsNameOrCode as an integer or a string value. For example, the following statements all set UnitsNameOrCode to inches.

Cell.ResultForce (visInches) = newValue

Cell.ResultForce (65) = newValue

Cell.ResultForce ("in") = newValue where "in" can also be any of the alternate strings representing inches, such as "inch", "in.", or "intCounter".

For a complete list of valid unit strings along with their corresponding Automation constants (integer values), see About units of measure.

Automation constants for representing units are declared by the Visio type library in member VisUnitCodes.

To specify internal units, pass a zero-length string (""). Internal units are inches for distance and radians for angles. To specify implicit units, you must use the Formula property.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.