XL97: Using "Checked", "Gray", and "Unchecked" in Macros

ID: Q157755


The information in this article applies to:


SYMPTOMS

In Microsoft Excel 97, when you run a Visual Basic for Applications macro, you may receive the following error message:

Compile error:
Invalid Qualifier


CAUSE

This behavior occurs when the following conditions are both true:

NOTE: This behavior does not apply to controls named "Grey".

This behavior is by design of Microsoft Excel.


WORKAROUND

You can avoid this problem by performing either of the following:


MORE INFORMATION

In 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


Keywords          : kberrmsg kbprg kbdta kbdtacode KbVBA xlvbmigrate 
Version           : WINDOWS:97
Platform          : WINDOWS 
Issue type        : 

Last Reviewed: July 2, 1999