Microsoft KB Archive/92405

{|
 * width="100%"|

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

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 2.x, 3.0, 4.0
 * Microsoft Excel for the Macintosh, versions 2.2, 3.0, 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.