Type cell (Text Fields section)

Microsoft Office ShapeSheet

Type cell (Text Fields section)

       Rows

Specifies a data type for the text field value.

Value

Description

0

String.

2

Number. Includes date, time, duration, and currency values as well as scalars, dimensions, and angles. Specify a format picture in the Format cell.

5

Date or time value. Displays days, months, and years, or seconds, minutes, and hours, or a combined date and time value. Specify a format picture in the Format cell.

6

Duration value. Displays elapsed time. Specify a format picture in the Format cell.

7

Currency value. Uses the system's current Regional Settings. Specify a format picture in the Format cell.

Remarks

You can also set the value of this cell using the Field dialog box (with a shape selected, click Field on the Insert menu).

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

Cell name:

Fields.Type[i]
where i = <1>, 2, 3…

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

Section index:

visSectionTextField

Row index:

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

Cell index:

visFieldType