PivotField.DataType property (Excel)

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

Syntax

expression.DataType

expression A variable that represents a PivotField object.

Example

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

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.