Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

Type Cell (Shape Data Section)

Specifies a data type for the shape data value.

Value

Description

Automation constant

0

String. This is the default.

visPropTypeString

1

Fixed list. Displays the list items in a drop-down combo box in the Define Shape Data dialog box. Specify the list items in the Format cell. Users can select only one item from the list.

visPropTypeListFix

2

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

visPropTypeNumber

3

Boolean. Displays FALSE and TRUE as items users can select from a drop-down list box in the Define Shape Data dialog box.

visPropTypeBool

4

Variable list. Displays the list items in a drop-down combo box in the Define Shape Data dialog box. Specify the list items in the Format cell. Users can select a list item or enter a new item that is added to the current list in the Format cell.

visPropTypeListVar

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.

visPropTypeDate

6

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

visPropTypeDuration

7

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

visPropTypeCurrency

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

Cell name:

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

To get a reference to the Type 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:

visCustPropsType

Show:
© 2015 Microsoft