Microsoft KB Archive/231088

= XL2000: Selected Text in Combo Box from Forms Toolbar Overflows into Worksheet =

Article ID: 231088

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q231088



SYMPTOMS
Characters that do not fit into the space in a combo box may be displayed to the right of the combo box in the underlying worksheet.



CAUSE
This problem occurs when the following conditions are true:
 * You create a combo box from the Forms toolbar.

-and-
 * You include a cell in the input range for the combo box that contains text longer than the width of the combo box.

-and-
 * You select the long text item in the combo box.

If the text of the input range cell is longer than the combo box, the additional characters extend beyond the box into the underlying spreadsheet. The selected text in the box is not truncated as expected.



RESOLUTION
To resolve this problem, obtain Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a).

To obtain SR-1/SR-1a, click the article number below to view the article in the Microsoft Knowledge Base:

245025 OFF2000: How to Obtain and Install Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a)

To temporarily work around this problem, use either of the following methods.

Method 1: Use a Larger Combo Box
Make the combo box larger than any text which is referenced, or truncate the text in the input range cells to fit the width of the combo box.

Method 2: Use a Different Type of Combo Box
Use the combo box from the Control Toolbox toolbar instead of the Forms toolbar.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was corrected in Microsoft Office 2000 SR-1/SR-1a.



MORE INFORMATION
When text spills beyond the combo box, some of the letters seem to disappear under the drop-down arrow, with the remaining letters appearing on the worksheet to the right of the combo box.

This problem does not occur with the combo box control from the Control Toolbox toolbar.

