View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default So then how to a get arrow keys to control a spinbutton?

Check out KeyDown event which returns the keycode as integer

If this post helps click Yes
---------------
Jacob Skaria


"Benjamin" wrote:

Microsoft stated:

The KeyPress event procedure fires only when a character key is pressed.
Character keys a

€¢Any printable keyboard character
€¢[Ctrl], combined with a character from the standard alphabet
€¢Y
€¢[Esc]
The KeyPress event does not occur for these keys, however:

€¢[Enter]
€¢F
€¢An arrow key
€¢A keystroke that causes the focus to move

So then how to a get arrow keys to control a spinbutton?