Excel: Number of Files Allowed in Linked List Box

 Last reviewed: September 12, 1996
Article ID: Q104225
The information in this article applies to:
  • Microsoft Excel for Windows, versions 3.0, 4.0, 4.0a
  • Microsoft Excel for OS/2, version 3.0

In a Microsoft Excel custom dialog box, there is a limit to the maximum number of files that can be displayed in a linked list box:

  • In Microsoft Excel version 4.0, this limit is approximately 850 files.
  • In Microsoft Excel version 3.0, this limit is approximately 780 files.

NOTE: These numbers may vary depending on the length of the filenames being displayed.

When you create a custom dialog box in Microsoft Excel, one of the objects that can be added to the dialog box is a linked list box. A linked list box usually consists of a list box, which contains the names of files in the current directory, and a text box, which contains the name of the currently selected file.

REFERENCES

"User's Guide 2," version 4.0, page 277-278 "User's Guide," version 3.0, page 637

KBCategory: kbusage
KBSubcategory:

Additional reference words: 3.00 4.00 4.00a linked-list



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: September 12, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.