Expand Minimize
This topic has not yet been rated - Rate this topic

Value cell (Text Fields section)

Office XP

Value cell (Text Fields section)

http://msdn.microsoft.com/en-us/library/aa158132(v=office.10) See also         http://msdn.microsoft.com/en-us/library/aa160115(v=office.10) 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 http://msdn.microsoft.com/en-us/library/aa141912(v=office.10) 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 http://msdn.microsoft.com/en-us/library/aa141916(v=office.10) CellsSRC property with the following arguments:

Section index:

visSectionProp

Row index:

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

Cell index:

visCustPropsValue

Did you find this helpful?
(1500 characters remaining)
© 2013 Microsoft. All rights reserved.