ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   key detection in user forms (https://www.excelbanter.com/excel-discussion-misc-queries/234569-key-detection-user-forms.html)

AlanGriffithKapitiNZ

key detection in user forms
 
I am writing an MSAccess simulator in Excel 2007 under Vista. In a form with
5 rows each of 6 buttons I want to be able to detect the pressing of
Up,Down,Left and Right keys.
I have tried all 3 methods (Private Sub UserForm_KeyDown,
_KeyPress and _KeyUp) and I can prove these are not working because I have
added a Stop statement as the first line of code in each,
and these are never executed.
Neither does it help to use a separate set of _keyUp etc for the individual
buttons.
Has anyone out there met this problem and/or solved it?
Please help if you can.


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

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