Export (0) Print
Expand All

BeforeKeyPress Event

Office 2003

Occurs when a user presses and releases 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_BeforeKeyPress(ByVal KeyAscii As Long, ByVal Cancel As ByRef)

Object    A ChartSpace , PivotTable , or Spreadsheet object.

KeyAscii    An integer that represents the key code of the key that was pressed or released.

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


Canceling this event does not prevent the KeyPress or KeyUp events from firing.

The sequence of keyboard-related events is:

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

© 2014 Microsoft