MultiSelect Property (Microsoft Forms)

This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010.

Indicates whether the object permits multiple selections.

Syntax

object.MultiSelect [= fmMultiSelect]

The MultiSelect property syntax has these parts:

Part

Description

object

Required. A valid object.

fmMultiSelect

Optional. The selection mode that the control uses.

Settings

The settings for fmMultiSelect are:

Constant

Value

Description

fmMultiSelectSingle

0

Only one item can be selected (default).

fmMultiSelectMulti

1

Pressing the SPACEBAR or clicking selects or deselects an item in the list.

fmMultiSelectExtended

2

Pressing SHIFT and clicking the mouse, or pressing SHIFT and one of the arrow keys, extends the selection from the previously selected item to the current item. Pressing CTRL and clicking the mouse selects or deselects an item.

Remarks

When the MultiSelect property is set to Extended or Simple, you must use the list box's Selected property to determine the selected items. Also, the Value property of the control is always Null.

The ListIndex property returns the index of the row with the keyboard focus.