XL98: ListBox Control Is Resized If Column Width Is Set to Zero

ID: Q183355


The information in this article applies to:
  • Microsoft Excel 98 Macintosh Edition


SYMPTOMS

When you add a ListBox control to a UserForm, the width of the ListBox may change unexpectedly.


CAUSE

This problem occurs if both of the following conditions are true:

  • You add ListBox control that has multiple columns.


  • -and-

  • You set the width of the first column in the ListBox to zero (0).



WORKAROUND

To work around this problem, use a value that is greater than zero for the width of the first column in a multicolumn ListBox control.


STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

Additional query words:

Keywords : kbdta xlvbainfo
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbbug


Last Reviewed: November 4, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.