ListStyle Property
This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010.
Specifies the visual appearance of the list in a ListBox or ComboBox.
Syntax
object.ListStyle [= fmListStyle]
The ListStyle property syntax has these parts:
Part |
Description |
|---|---|
object |
Required. A valid object. |
fmListStyle |
Optional. The visual style of the list. |
Settings
The settings for fmListStyle are:
Constant |
Value |
Description |
|---|---|---|
fmListStylePlain |
0 |
Looks like a regular list box, with the background of items highlighted. |
fmListStyleOption |
1 |
Shows option buttons, or check boxes for a multi-select list (default). When the user selects an item from the group, the option button associated with that item is selected and the option buttons for the other items in the group are deselected. |
Remarks
The ListStyle property lets you change the visual presentation of a ListBox or ComboBox. By specifying a setting other than fmListStylePlain, you can present the contents of either control as a group of individual items, with each item including a visual cue to indicate whether it is selected.
If the control supports a single selection (the MultiSelect property is set to fmMultiSelectSingle), the user can press one button in the group. If the control supports multi-select, the user can press two or more buttons in the group.