Limit of List Boxes in Custom Dialog Box Causes Macro Error

• Microsoft Excel for Windows, versions 2.x, 3.0, 4.0
• Microsoft Excel for OS/2 versions 2.2, 2.21, and 3.0
• Microsoft Excel for the Macintosh, versions 2.x, 3.0, 4.0

SUMMARY

When using Microsoft Excel versions 2.x and 3.0, you have a limit of four list boxes. If more than four list boxes are used, a macro error will display pointing to the cell that contains the fifth list box. If more than four list boxes are needed, multiple dialog boxes must be created with up to four list boxes on each.

Excel version 4.0. is limited to eight list boxes.

REFERENCES

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

"Microsoft Excel User's Guide," for Windows and OS/2, version 3.0, page 631

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

Additional query words:

Keywords :
Version :
Platform :
Issue type :