Excel: Limits for Number of Items in Excel Custom Data Forms

 Last reviewed: July 16, 1997
Article ID: Q92405

The information in this article applies to:
  • Microsoft Excel for Windows, versions 2.x, 3.0, and 4.0
  • Microsoft Excel for the Macintosh, versions 2.2, 3.0, and 4.0

SUMMARY

The custom data form in Microsoft Excel is limited to the following number of items:

  • The total number of items is 64.
  • The total number of items that can take or return arguments is 31.

    Note: In versions prior to 4.0, this total was 32. In version 4.0 of Microsoft Excel, a Help button has been added to the data form; this reduces the number of items from 32 to 31.

  • The total number of text characters is 1,024.

If you exceed these limitations, Microsoft Excel will display the following error message: 

   Data_Form is not correct.

MORE INFORMATION

Any items in your custom data form that exceed the specified limits will not function properly when you run your data form.

Microsoft Excel will also display the error message 

   Data_Form is not correct.
under the following conditions:
  • You have invalid numbers in the dialog box description for your custom data form in the Item, X, Y, Width, or Height columns.

    -or-

  • The area defined as your dialog box description is less than seven columns wide.

    -or-

  • The range you defined as Data_Form is not the correct range for your dialog box description.

REFERENCES

"Microsoft Excel User's Guide 2," version 4.0, page 270

"Microsoft Excel User's Guide," version 3.0, page 631

"Microsoft Excel for Windows Functions and Macros," version 2.0, page 217

Additional query words: 2.0 2.00 2.01 2.1 2.10 2.1c 2.10c 2.1d
2.10d 2.2 2.20 3.0 3.00 4.0 4.00

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: July 16, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.