MXL: Check Box Assigned to Macro May Fail

 Last reviewed: February 3, 1998
Article ID: Q148670
The information in this article applies to:
  • Microsoft Excel for the Macintosh, versions 5.0, 5.0a
  • Microsoft Excel 98 Macintosh Edition

SYMPTOMS

In the versions of Microsoft Excel listed at the beginning of this article, when you display a custom dialog sheet that contains a check box, you may receive the following error message: 

   Run-time error '1004':
   Show method of DialogSheet class failed

CAUSE

You may receive the run-time '1004' error message when the following conditions are true:

  • The dialog sheet contains an edit box that has the Edit Validation option set to Reference. (To view this option, click Object on the Format menu, and then click the Control tab.) 

        -and-
  • You run a Sub procedure that displays the dialog sheet, you enter a range into the edit box, and you select or clear the check box.

NOTE: If there is no range reference placed into the edit box, but the check box is either selected or cleared, the Sub procedure assigned to the check box will not run and the dialog sheet is dismissed.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: 5.00 5.0a XL98 XL5 uncheck unchecked
Keywords : kbcode kbprg xlmac PgmOthr
Version : MACINTOSH:5.0,5.0a,98
Platform : MACINTOSH
Issue type : kbbug

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 3, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.