Value cell (Text Fields section)

Microsoft Office ShapeSheet

Value cell (Text Fields section)

       Rows

Contains the function for a field.

Remarks

You can set the value of this cell using the Field dialog box (click Field on the Insert menu). To see a list of functions, see the Functions list in this Developer Reference.

Formulas entered in this cell are overridden by values entered in the Custom Properties dialog box. This is true even if you use the GUARD function to protect the formula.

To reference the Value cell by name from another formula, or from a program using the Cells property, use:

Cell name:

Prop.Name.Value
where Prop.Name is the row name

To reference the Value cell by index from a program, use the CellsSRC property with the following arguments:

Section index:

visSectionProp

Row index:

visRowProp + i
where i = 0, 1, 2…

Cell index:

visCustPropsValue