Choices Property [Excel 2003 VBA Language Reference]

  • Article

Returns an Array of String values that contains the choices offered to the user by the ListLookUp, ChoiceMulti, and Choice data types of the

Visit DefaultValue

property. Read-only Variant.

expression. Choices

expression Required. An expression that returns a

Visit ListDataFormat

object.

Remarks

In Microsoft Excel, you cannot set any of the properties associated with the ListDataFormat object. You can set these properties, however, by modifying the list on the server that is running Microsoft Windows SharePoint Services.

Example

The following example displays the setting of the Choice property for the third column in a list that is linked to a SharePoint list. In this example, it is assumed that the DefaultValue property has been set to the Choice, ChoiceMulti, or ListLookup data type.

Sub PrintChoices()
   Dim wrksht As Worksheet
   Dim objListCol As ListColumn
   
   Set wrksht = ActiveWorkbook.Worksheets("Sheet1")
   Set objListCol = wrksht.ListObjects(1).ListColumns(3)

   Debug.Print objListCol.ListDataFormat.Choices
End Sub

Applies to | ListDataFormat Object