List box changes size

[Karin Iversen]

MS Excel 2003 service pack 3.

In a spreadsheet one of the list boxes shrinks every time the document is
closed and opened again. The other list box does not change size and the
properties appear to be identical.

How comes?

Karin

 

[Shane Devenshire]

Hi,

If their properties are the same, you might delete the offending listbox and
copy one of the "good" list boxes and then adjust it as needed.

If this doesn't help, you might tell us what version of Excel you are using,
what type of list box - Form or Control Toolbox, and where it's located - on
a user form and imbedded in the spreadsheet. Also, if there is code
associated with it you might show that also.