MXL: Check Box Assigned to Macro May Fail

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 PgmOthr xlmac 
Version           : MACINTOSH:5.0,5.0a,98
Platform          : MACINTOSH
Issue type        : kbbug

Last Reviewed: February 4, 1998