Microsoft KB Archive/96266

= Microsoft Knowledge Base =

Excel: More Than 8 Picture Buttons Causes Macro Error
Last reviewed: September 12, 1996

Article ID: Q96266

The information in this article applies to:


 * Microsoft Excel for Windows, versions 4.0 and 4.0a
 * Microsoft Excel for the Macintosh, version 4.0

SUMMARY
In Microsoft Excel versions 4.0 (and Microsoft Excel version 4.0a for Windows) you can use picture buttons in a dialog box. Dialog box tables are limited to eight (8) picture buttons (picture buttons have an item number of 23). If a dialog box contains more than eight picture buttons, the macro will error when it evaluates the line that calls the dialog box and you will receive the following error message

Error in dialog box at Sheetname!cell where Sheetname is the name of the macro sheet and cell is the reference to the cell containing the ninth picture button item number.