List DataFormat Properties

Name

Returns

Description

AllowFillIn

Boolean

Determines if the user can provide values or if they are restricted to using information from a list

Choices

String Array

Contains a string array of choices

DecimalPlaces

Long

Determines the number of decimal places to show

DefaultValue

Variant

Default value to use for this item

Name

Returns

Description

IsPercent

Boolean

Determines if this item should be displayed as a percentage

LCID

Long

Determines the currency symbol that is used

MaxCharacters

Long

The maximum number of characters that can be entered

MaxNumber

Variant

The largest number used

MinNumber

Variant

The minimum number that can be used

ReadOnly

Boolean

Determines if the item should be read-only and therefore disallow changes

Required

Boolean

Determines if the item is required

Type

XlListDataType

Used when a item links to a SharePoint site

0 0

Post a comment