XlListDataType enumeration (Excel)
Specifies the data type of a list column connected to a Microsoft SharePoint Foundation site.
| Name | Value | Description |
|---|---|---|
| xlListDataTypeCheckbox | 9 | Check box. |
| xlListDataTypeChoice | 6 | Single-choice field. |
| xlListDataTypeChoiceMulti | 7 | Multiple-choice field. |
| xlListDataTypeCounter | 11 | Counter. |
| xlListDataTypeCurrency | 4 | Currency. |
| xlListDataTypeDateTime | 5 | Date/time. |
| xlListDataTypeHyperLink | 10 | Hyperlink. |
| xlListDataTypeListLookup | 8 | Lookup list. |
| xlListDataTypeMultiLineRichText | 12 | Rich text format with multiple lines. |
| xlListDataTypeMultiLineText | 2 | Plain text with multiple lines. |
| xlListDataTypeNone | 0 | Type not specified. |
| xlListDataTypeNumber | 3 | Numerical. |
| xlListDataTypeText | 1 | Plain text. |
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.