PivotField.DataType Property

Syntax

expression.DataType

expression A variable that represents a PivotField object.

Example

This example displays the data type of the field named "ORDER_DATE."

Visual Basic for Applications

Visual Basic for Applications
`Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable Select Case pvtTable.PivotFields("ORDER_DATE").DataType Case Is = xlText MsgBox "The field contains text data" Case Is = xlNumber MsgBox "The field contains numeric data" Case Is = xlDate MsgBox "The field contains date data" End Select`

Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable Select Case pvtTable.PivotFields("ORDER_DATE").DataType Case Is = xlText MsgBox "The field contains text data" Case Is = xlNumber MsgBox "The field contains numeric data" Case Is = xlDate MsgBox "The field contains date data" End Select

Returns a XlPivotFieldDataType value that represents the type of data in the PivotTable field.

See also: