BeforeKeyDown Event

Occurs when a user presses a key on the keyboard, but before the control has processed the keystroke. 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_BeforeKeyDown(ByValKeyCodeAsLong, ByValShiftAsLong, ByValCancelAsByRef)

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.


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

Applies to | ChartSpace Object | PivotTable Object | Spreadsheet Object

See Also | BeforeKeyPress Event | BeforeKeyUp Event | KeyDown Event | KeyPress Event | KeyUp Event