Microsoft KB Archive/67813

{|
 * width="100%"|

Limit of List Boxes in Custom Dialog Box Causes Macro Error

 * }

-

The information in this article applies to:


 * 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.