XL97: Scroll Bar Missing If Control Text Is Too Long

 Last reviewed: January 7, 1998
Article ID: Q172960
The information in this article applies to:
  • Microsoft Excel 97 for Windows

SYMPTOMS

When you click List Box on the Control Toolbox toolbar and place the control on a Microsoft Excel 97 worksheet, the horizontal scroll bar may disappear.

CAUSE

This behavior occurs when the following conditions are true:

  • The control is linked to a cell in which the number of characters exceeds the width of the list box. 

        -and-
  • You are using the List Box or Combo Box control from the Forms Toolbar or the Control Toolbox toolbar.

This behavior occurs even if text in the control is truncated. Note that other controls on the Forms toolbar or the Control Toolbox toolbar may truncate text if it is too long and fail to display horizontal scroll bars that allow you to scroll through the control.

WORKAROUND

To work around this behavior, make the control wide enough to display the contents of the linked cell.

STATUS

This behavior is by design of Microsoft Excel 97.

REFERENCES

For more information about list boxes, click the Index tab in Microsoft Excel Help, type the following text: 

   list boxes
and then double-click the selected text to go to the "about adding buttons, checkboxes, and other controls" topic.

Additional query words: XL97
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbprb
Solution Type : kbworkaround

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: January 7, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.