BeforeKeyPress Event
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.
Remarks
Canceling this event does not prevent the KeyPress or KeyUp events from firing.
The sequence of keyboard-related events is:
- BeforeKeyDown
- KeyDown
- BeforeKeyPress
- KeyPress
- BeforeKeyUp
- KeyUp