Excel: Item Selected in Linked List Dialog Box Not Highlighted

 Last reviewed: November 30, 1994
Article ID: Q93576
The information in this article applies to:
  • Microsoft Excel for Windows, versions 3.0 and 4.0
  • Microsoft Excel for the Macintosh, versions 3.0 and 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

KBCategory: kbusage
KBSubcategory:

Additional reference words: 4.00 4.0a 4.00a 3.00 display



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 30, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.