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

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - So then how to a get arrow keys to control a spinbutton? (https://www.excelbanter.com/excel-programming/436102-so-then-how-get-arrow-keys-control-spinbutton.html)

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

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?

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?