Occurs whenever the user presses a key on the keyboard. If the user holds the key down, this event repeats itself at the key-repeat interval that has been set on the user's computer.
Private Sub Object_KeyDown(ByVal KeyCode As Long, ByVal Shift As Long)
Object The name of the ChartSpace, PivotTable or Spreadsheet object that you are trapping this event for.
KeyCode A Long that represents the key code of the key that was pressed or released.
Shift The state of the SHIFT, CTRL, and ALT keys. Returns 1 if the SHIFT key was pressed, 2 if the CTRL key was pressed, and 4 if the ALT key was pressed. Returns 0 if neither the SHIFT, CTRL, nor ALT keys were pressed.
For information about using events with VBScript, see Declaring and Using Event Procedures in VBScript .
The sequence of keyboard-related events is: