XL98: Selected Items in MS Excel 5.0 Dialog Box Move (186760)


The information in this article applies to:

  • Microsoft Excel 98 Macintosh Edition
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.

MORE INFORMATION

Example of the problem

To see an example of the problem described in this article, follow these steps:
  1. Start Microsoft Excel 98.
  2. Type the following in Sheet1 of a new workbook: 
          A1: 1
      A2: 2
  3. Select cells A1:A2. Use the fill handle to fill values down to row 20.
  4. 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.
  5. Draw a list box on the dialog sheet. Double-click the list box.
  6. Click the Control tab. In the Input range box type Sheet1!A1:A20. In the Cell link box type Sheet1!C1. Click OK.
  7. On the Forms toolbar, click Run Dialog.
  8. Scroll down to the end of the list and select any item except for the last item.
The selected item shifts to the bottom of the viewable selection.

REFERENCES

For more information about list boxes, click the Office Assistant, type list box, click Search, and then click to view "Types of buttons, check boxes, and other controls on the Forms toolbar."

NOTE: If the Assistant is hidden, click the Office Assistant button on the Standard toolbar. If Microsoft Help is not installed on your computer, please see the following article in the Microsoft Knowledge Base:

179216 OFF98: How to Use the Microsoft Office Installer Program

Modification Type:MajorLast Reviewed:9/11/2002
Keywords:kbbug KB186760
©2002 Microsoft Corporation. All rights reserved.