Excel: Item Selected in Linked List Dialog Box Not Highlighted

ID: Q93576

The information in this article applies to:

Microsoft Excel for Windows, versions 3.0, 4.0
Microsoft Excel for the Macintosh, versions 3.0, 4.0
Microsoft Excel for OS/2, version 3.0

SUMMARY

In Microsoft Excel, if a custom dialog box contains a list box that precedes a linked list box, if you select an item in the linked list box and then close the dialog box, the selected item may not be highlighted when you reopen the dialog box.

This problem is a display problem and does not affect the information returned by the linked list box; the selected item text appears in the text box of the linked list box and the initial/result column in the dialog box definition table contains the correct item number and item text.

MORE INFORMATION

The selected items are not highlighted under the following conditions:

The list box appears above the linked list box in the dialog box definition table for your custom dialog box.

-and-

The list associated with your linked list box is longer than the list associated with your list box.

All items in the linked list box that are at a position greater than the length of the list associated with the list box won't be highlighted when you reopen the dialog box. For example, suppose the list associated with your linked list box contains ten items, and the list associated with your list box contains five items. If you select the sixth item in your linked list box and then close and reopen the dialog box, the selected item in the linked list box won't be highlighted. If you select the fifth item and do the same thing, it will be highlighted when you reopen the dialog box.

Workaround

To work around this problem, change the order of the list boxes within your dialog definition table: move the information for the list box (item 15) to any position below the information for the linked list box (item 16) in your dialog box definition table.

Note: The linked list box is preceded by a text box (item 6). Be sure not to separate the linked list box from its text box.

REFERENCES

"Microsoft Excel User's Guide 2," version 4.0, pages 272-280
"Microsoft Excel User's Guide," version 3.0, pages 624-635

Additional query words: 4.0a 4.00a display


Keywords          : 
Version           : 
Platform          : 
Issue type        :

Last Reviewed: March 30, 1999