To run a macro when the KeyDown or KeyUp event occurs, set the OnKeyDown or OnKeyUp property to the name of the macro.
You can use a KeyDown or KeyUp macro to respond whenever the user presses or releases a key while a form or control has the focus. However, macros can’t return the key code and determine which key was pressed, so you typically use event procedures with this event.
You can’t use the CancelEvent action in a KeyDown or KeyUp macro.
KeyDown, KeyUp Events — Event Procedures.