Q125899 - {CLEAR} Keystroke Is Supported Using SendKeys Command

{CLEAR} Keystroke Is Supported Using SendKeys Command

Q125899

The information in this article applies to:

Microsoft Visual Basic for Applications version 1.0
Microsoft Excel for Windows, versions 5.0, 5.0c
Microsoft Project for Windows, version 4.0

SUMMARY

The CLEAR keystroke is supported using the SendKeys statement or SendKeys method, even though this key is not included in the list of keys available in the Visual Basic Reference. To send the CLEAR keystroke using the SendKeys command in a Visual Basic, Applications Edition, procedure, use the key code {CLEAR} as in the following examples:


   SendKeys "{CLEAR}"
 
   Application.SendKeys "{CLEAR}"

Note that you cannot use the SendKeys method (Application.SendKeys command) in Microsoft Project.

MORE INFORMATION

The {CLEAR} key code is not documented in the Visual Basic Reference because the CLEAR key no longer exists on most keyboards. However, this keystroke is supported by the SendKeys command. If your keyboard does not have a CLEAR key, using the SendKeys command with the {CLEAR} key code does not have any effect.

Note that all of the named keys (except {Clear}) in the Visual Basic, Standard Edition, version 3.0 Help file are documented in the Visual Basic Reference.

REFERENCES

For more information about the SendKeys Statement or the SendKeys Method, choose the Search button in the Visual Basic Reference and type:

SendKeys

Additional query words:

Keywords :
Issue type :
Technology : kbExcelSearch kbZNotKeyword6 kbExcel500 kbProjectSearch kbVBASearch kbZNotKeyword3 kbExcel500c kbProject400 kbVBA100