Microsoft KB Archive/172960

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 10:06, 21 July 2020 by X010 (talk | contribs) (Text replacement - """ to """)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Knowledge Base

Article ID: 172960

Article Last Modified on 10/22/2000


  • Microsoft Excel 97 Standard Edition

This article was previously published under Q172960


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.


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.


  • 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.


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


This behavior is by design of Microsoft Excel 97.


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

Keywords: kbprb KB172960