ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   trap arrow key press in userform (https://www.excelbanter.com/excel-programming/342204-trap-arrow-key-press-userform.html)

ben

trap arrow key press in userform
 
does anyone know a way to trap the pressing of arrow keys in a userform

OnKey method will not trigger in userform and keypress event for textboxes
returns nothing for arrow keys

any other ideas? Please
ben

--
When you lose your mind, you free your life.

Tom Ogilvy

trap arrow key press in userform
 
what about keyup and keydown?

from help on these events:

The KeyDown and KeyUp events are typically used to recognize or distinguish
between:

a.. Navigation keys, such as HOME, END, PAGEUP, PAGEDOWN, UP ARROW, DOWN
ARROW, RIGHT ARROW, LEFT ARROW, and TAB.


--
Regards,
Tom Ogilvy

"ben" (remove this if mailing direct) wrote in message
...
does anyone know a way to trap the pressing of arrow keys in a userform

OnKey method will not trigger in userform and keypress event for textboxes
returns nothing for arrow keys

any other ideas? Please
ben

--
When you lose your mind, you free your life.




ben

trap arrow key press in userform
 
Yay for Tom!!
now i feel stupid I should have tried that first before coming begging for
help
thank you sir
ben

--
When you lose your mind, you free your life.


"Tom Ogilvy" wrote:

what about keyup and keydown?

from help on these events:

The KeyDown and KeyUp events are typically used to recognize or distinguish
between:

a.. Navigation keys, such as HOME, END, PAGEUP, PAGEDOWN, UP ARROW, DOWN
ARROW, RIGHT ARROW, LEFT ARROW, and TAB.


--
Regards,
Tom Ogilvy

"ben" (remove this if mailing direct) wrote in message
...
does anyone know a way to trap the pressing of arrow keys in a userform

OnKey method will not trigger in userform and keypress event for textboxes
returns nothing for arrow keys

any other ideas? Please
ben

--
When you lose your mind, you free your life.






All times are GMT +1. The time now is 02:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com