ListDataFormat Property

Microsoft Excel Visual Basic

ListDataFormat Property

Returns a ListDataFormat object for the ListColumn object. Read-only.

expression.ListDataFormat

expression    Required. An expression that returns a ListColumn object.

Remarks

Use the ListDataFormat property to return a ListDataFormat object.

The following code returns a ListDataFormat object for the Products column of a list in the active worksheet.

    
Dim objListDataFormat as ListDataFormat

set objListDataFormat = ActiveSheet.ListColumns("Products").ListDataFormat