ListDataFormat Object Members

  • Article
Excel Developer Reference

The ListDataFormat object holds all the data type properties of the ListColumn object. These properties are read-only.

Properties

  Name Description
Bb242351.properties(en-us,office.12).gif AllowFillIn Returns a Boolean value indicating whether users can provide their own data for cells in a column (rather than being restricted to a list of values) for those columns that supply a list of values. Returns False for lists that are not linked to a SharePoint site. Also returns False if the column is not a specified as choice or multi-choice. Read-only Boolean.
Bb242351.properties(en-us,office.12).gif Application When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
Bb242351.properties(en-us,office.12).gif Choices Returns an Array of String values that contains the choices offered to the user by the ListLookUp, ChoiceMulti, and Choice data types of the DefaultValue property. Read-only Variant.
Bb242351.properties(en-us,office.12).gif DecimalPlaces Returns a Long value that represents the number of decimal places to show for the numbers in the ListColumn object. Read-only Long.
Bb242351.properties(en-us,office.12).gif DefaultValue Returns Variant representing the default data type value for a new row in a column. The Nothing object is returned when the schema does not specify a default value. Read-only Variant.
Bb242351.properties(en-us,office.12).gif IsPercent Returns a Boolean value. Returns True only if the number data for the ListColumn object will be shown in percentage formatting. Read-only Boolean.Read-only
Bb242351.properties(en-us,office.12).gif lcid Returns a Long value that represents the LCID for the ListColumn object that is specified in the schema definition. Read-only Long.
Bb242351.properties(en-us,office.12).gif MaxCharacters Returns a Long containing the maximum number of characters allowed in the ListColumn object if the Type property is set to xlListDataTypeText or xlListDataTypeMultiLineText. Read-only Long.
Bb242351.properties(en-us,office.12).gif MaxNumber Returns a Variant containing the maximum value allowed in this field in the list column. Read-only Variant.
Bb242351.properties(en-us,office.12).gif MinNumber Returns a Variant containing the minimum value allowed in this field in the list column. This can be a negative floating point number. Read-only Variant.
Bb242351.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb242351.properties(en-us,office.12).gif ReadOnly Returns True if the object has been opened as read-only. Read-only Boolean.
Bb242351.properties(en-us,office.12).gif Required Returns a Boolean value indicating whether the schema definition of a column requires data before the row is committed. Read-only Boolean.
Bb242351.properties(en-us,office.12).gif Type Returns an XlListDataType value that represents the data type of the list column.