XL97: Using "Checked", "Gray", and "Unchecked" in MacrosLast reviewed: February 27, 1998Article ID: Q157755 |
The information in this article applies to:
SYMPTOMSIn Microsoft Excel 97, when you run a Visual Basic for Applications macro, you may receive the following error message:
Compile error: Invalid Qualifier CAUSEThis problem will occur if the following conditions are both true:
WORKAROUNDYou can avoid this problem by performing either of the following:
STATUSThis behavior is by design of Microsoft Excel 97.
MORE INFORMATIONIn earlier versions of Microsoft Excel, the words "Checked", "Gray", and "Unchecked" have no special meaning. However, in Microsoft Excel 97, these three words are global constants belonging to the Stdole Type Library. Because of this, it is not possible to refer to these constants by enclosing them in brackets when running a macro in Microsoft Excel 97. Use either of the workarounds shown above to eliminate this problem.
|
Additional query words: XL97 8.00
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |