BeforeKeyDown Event

Private Sub Object_BeforeKeyDown(ByVal KeyCode As Long, ByVal Shift As Long, ByVal Cancel As ByRef)

Object    A ChartSpace , PivotTable , or Spreadsheet object.

KeyCode    An integer 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.

Cancel     Set the Value property of this object to True to cancel the keystroke.

Remarks

Canceling this event also cancels the BeforeKeyPress and KeyPress events, but does not prevent the the KeyDown or KeyUp events from firing.

The sequence of keyboard-related events is:

1. BeforeKeyDown
2. KeyDown
3. BeforeKeyPress
4. KeyPress
5. BeforeKeyUp
6. KeyUp