This documentation is archived and is not being maintained.

XlListDataType Enumeration

Office 2007
Specifies the data type of a list column connected to a Microsoft Windows SharePoint Services site.

Version Information
 Version Added:  Excel 2007

NameValueDescription
xlListDataTypeCheckbox9Check box.
xlListDataTypeChoice6Single-choice field.
xlListDataTypeChoiceMulti7Multiple-choice field.
xlListDataTypeCounter11Counter.
xlListDataTypeCurrency4Currency.
xlListDataTypeDateTime5Date/time.
xlListDataTypeHyperLink10Hyperlink.
xlListDataTypeListLookup8Lookup list.
xlListDataTypeMultiLineRichText12Rich text format with multiple lines.
xlListDataTypeMultiLineText2Plain text with multiple lines.
xlListDataTypeNone0Type not specified.
xlListDataTypeNumber3Numerical.
xlListDataTypeText1Plain text.


Show: