Occurs whenever the user presses and releases a key on the keyboard. Keyboard events occur in the following order: KeyDown, KeyPress, KeyUp.
Syntax
Private Sub Object_KeyPress(EventInfo)
EventInfo The SpreadsheetEventInfo or WCChartEventInfo object that contains information about the event.
Remarks
For information about using events with VBScript, see Declaring and Using Event Procedures in VBScript.