ShowDropButtonWhen property

Specifies when to show the drop-down button for a ComboBox or TextBox.

Syntax

object.ShowDropButtonWhen [= fmShowDropButtonWhen ]

The ShowDropButtonWhen property syntax has these parts:

Part Description
object Required. A valid object.
fmShowDropButtonWhen Optional. The circumstances under which the drop-down button will be visible.

Settings

The settings for fmShowDropButtonWhen are:

Constant Value Description
fmShowDropButtonWhenNever 0 Do not show the drop-down button under any circumstances.
fmShowDropButtonWhenFocus 1 Show the drop-down button when the control has the focus.
fmShowDropButtonWhenAlways 2 Always show the drop-down button.

Remarks

For a ComboBox, the default value is fmShowDropButtonWhenAlways.

For a TextBox, the default value is fmShowDropButtonWhenNever.

See also

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.