XL97: Data Validation Message May Not Disappear (173417)
The information in this article applies to:
- Microsoft Excel 97 for Windows
This article was previously published under Q173417 SYMPTOMS
After a data validation input message appears for a cell, the message may
not disappear when you select another cell.
CAUSE
This problem occurs if both of the following conditions are true:
- An OnKey Visual Basic for Applications procedure is in memory.
-and-
- The OnKey procedure selects a cell other than the active cell.
RESOLUTION
To resolve this problem, click any cell in the active worksheet.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
This problem no longer occurs in Microsoft Excel 2000.
REFERENCES
For more information about OnKey macros, click the Office Assistant in the
Visual Basic Editor, type onkey, click Search, and then click to view
"OnKey Method."
NOTE: If the Assistant is hidden, click the Office Assistant button on the
Standard toolbar. If Microsoft Help is not installed on your computer,
please see the following article in the Microsoft Knowledge Base:
120802Office: How to Add/Remove a Single Office Program or Component
Modification Type: | Major | Last Reviewed: | 6/23/2005 |
---|
Keywords: | kbdtacode kbProgramming KB173417 |
---|
|