Microsoft KB Archive/115694

= Microsoft Knowledge Base =

XL: List Box Text Appears Clipped or Is Not Displayed
Last reviewed: March 27, 1997

Article ID: Q115694

5.00 5.00c 7.00 7.00a | 5.00 5.00a WINDOWS | MACINTOSH kbusage

The information in this article applies to:


 * Microsoft Excel for Windows 95, versions 7.0, 7.0a
 * Microsoft Excel for Windows, versions 5.0, 5.0c
 * Microsoft Excel for the Macintosh, versions 5.0, 5.0a

SYMPTOMS
In Microsoft Excel, the text in a list box on a worksheet disappears or is clipped when you decrease the row height or hide a row on the worksheet that contains the list box.

CAUSE
This behavior occurs when the list box is grouped with another object, and the Move And Size With Cells option is selected for the group object. When you group two or more objects, this option is selected by default on the Properties tab of the Format Object dialog box. When this option is selected, the height of the object increases and decreases with the height of the cells that contain the object.

When you create a list box, the minimum height you can give the list box is approximately two rows on a worksheet. When this minimum height is decreased, the items in the list box become clipped, and eventually do not display. Additionally, the list box scroll bar arrows disappear when the list box is sized to less than the minimum height.

Note that when you select a list box that is not contained in a group of objects, the Move And Size With Cells option is not available.

WORKAROUND
To avoid this behavior when you group a list box and then change the height of the cells that contain the group object, set the Object Positioning option for the group object to either of the following:

 Move But Don't Size With Cells -or- Don't Move Or Size With Cells