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.
Remarks
For information about using events with VBScript, see Declaring and Using Event Procedures in VBScript .
The sequence of keyboard-related events is:
- BeforeKeyDown
- KeyDown
- BeforeKeyPress
- KeyPress
- BeforeKeyUp
- KeyUp