Microsoft KB Archive/186760

= XL98: Selected Items in MS Excel 5.0 Dialog Box Move =

Article ID: 186760

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q186760



SYMPTOMS
When you select an item in a list box, the list box may be scrolled so that the selected item is displayed at the bottom of the visible items in the list.



CAUSE
This problem occurs when the following conditions are true:
 * You are using a list box on an MS Excel 5.0 dialog sheet. -and-


 * You specify a cell link for the list box.

To see example of this problem, please see the "More Information" section in this article.



WORKAROUND
To work around this problem, do not specify a cell link for the list box. To remove a cell link from a list box, follow these steps:
 * 1) Switch to the dialog sheet in your workbook.
 * 2) Double-click the list box.
 * 3) Click the Control tab in the Format Control dialog box.
 * 4) Clear the Cell Link box. Click OK.

When you now run the dialog sheet, the items are not moved in the list box.



STATUS
Microsoft has confirmed this to be a problem in Microsoft Excel 98 Macintosh Edition.



Example of the problem
To see an example of the problem described in this article, follow these steps:  Start Microsoft Excel 98.  Type the following in Sheet1 of a new workbook:      A1: 1 A2: 2  Select cells A1:A2. Use the fill handle to fill values down to row 20. Hold down the CONTROL key and click one of the sheet tabs. Click Insert on the shortcut menu that appears. Click MS Excel 5.0 Dialog and click OK. Draw a list box on the dialog sheet. Double-click the list box.</li> Click the Control tab. In the Input range box type Sheet1!A1:A20. In the Cell link box type Sheet1!C1. Click OK.</li> On the Forms toolbar, click Run Dialog.</li> Scroll down to the end of the list and select any item except for the last item.</li></ol>

The selected item shifts to the bottom of the viewable selection.

<div class="references_section">