Excel: Custom Dialog Box Limits
ID: Q89173
|
The information in this article applies to:
-
Microsoft Excel for Windows, versions 2.x, 3.0, 4.0
-
Microsoft Excel for the Macintosh, versions 1.x, 2.x, 3.0, 4.0
-
Microsoft Excel for OS/2, versions 2.2, 3.0
SUMMARY
In Microsoft Excel, attempting to display a custom dialog box that has
more items than the specified limits, results in the error message:
Error in dialog box at <location> (versions 3.0 and 4.0)
-OR-
Illegal dialog value (versions 1.x and 2.x)
The limits on items in custom dialog boxes in Microsoft Excel are:
Version 4.0
- 64 total items
- 32 items that can accept or return values.
- 8 list boxes
- 1024 text characters
Version 3.0 and earlier
- 64 total items
- 32 items that can accept or return values
- 4 list boxes
- 1024 text characters
MORE INFORMATION
Items that can take or return arguments are items that either read
some value from the initial/result column of the dialog definition
table, write some value to the initial/result column, or both.
Combination and Linked list boxes accept and return values through
their linked text edit boxes. Most of these list boxes also accept and
return a list index value in the initial/result column. Therefore you
would count the list box and the text edit box associated with it as
separate items. The exception to this is the Linked drive and
directory list box, and the Directory text box (items 19 & 20 Windows
only). These boxes ignore the initial/result column.
The following items can take or return arguments:
Item
Number Item
-------- --------------------------------------------------------
6 Text edit box
7 Integer edit box
8 Number edit box
9 Formula edit box
10 Reference edit box
11 Options button group
13 Check box
15 List box
16 Linked list box
18 Linked file list box (Windows only)
21 Drop-down list box
22 Drop-down combination edit/list box
REFERENCES
"Microsoft Excel User's Guide 2," version 4.0, pages 263-281
"Microsoft Excel User's Guide," version 3.0, pages 624-641
"Microsoft Excel for Windows, Functions and Macros," version 2.x,
pages 204-218
"Microsoft Excel Functions and Macros, Apple Macintosh Series,"
version 2.x, pages 164-178
Additional query words:
1.00 1.03 1.04 1.06 1.50 2.00 2.01 2.10 2.20 2.21
Keywords :
Version :
Platform :
Issue type :