ResultForce property
Sets a cell's value, even if the cell's formula is protected with the GUARD function.
Version added
2.0
Syntax
| |
|
object |
Required. An expression that returns a Cell object. |
|
unitsNameOrCode |
Required Variant. The units to use when setting the cell's value. |
|
newValue |
Required Double. The new value for the cell. |
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.
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 "i".
For a complete list of valid unit strings along with 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.