Purpose

.AutoResizeListBoxHeight turns on or off the Dynamic Resizing functionality for the y-axis (vertical) for all List Boxes.

Object Type

Application

Syntax

Setting:           Application.AutoResizeListBoxHeight = Value

Retrieving:       Variable = Application.AutoResizeListBoxHeight

Operation

Value is the setting for the property (TRUE or 1 = Disabled, FALSE or 0 = Enabled)
Variable is a numeric variable

Remarks

This is an Application property that enables or disables Dynamic Resizing for all List Boxes along the y-axis where the MaxHeight property is not set. If the maximum height and width values are not set or set to zero, then the Application property is used to determine the resizing behaviour.

Example

To enable the resizing of List Boxes' height:

Application.AutoResizeListBoxHeight = TRUE