XL97: Data Validation Message May Not Disappear

Example

1. Save and close any open workbooks, and then create a new workbook.
2. Select cell A1, and then click Validation on the Data menu.
3. On the Input Message tab, enter any text in the Input Message box, and then click OK.
4. Press ALT+F11 to start the Visual Basic Editor.
5. On the Insert menu click Module.
6. Enter the following code in the module:

          Sub test()
             Application.OnKey "~", "test2"
          End Sub
   
          Sub test2()
             Range("c1").Select
          End Sub
   						

7. Run the test procedure.
   
   When you type data in a cell and press ENTER, the test2 procedure automatically runs.
8. Press ALT+F11 to switch to Microsoft Excel.
9. Select cell A1.
   
   The input message you typed in step 3 is displayed next to cell A1.
   
   NOTE: The input message is displayed by the Office Assistant if the Office Assistant is visible.
10. Type any text, and then press Enter.