Hi,
how can I observe the keyboard events in excel 2010 for all excel sheets?
I want show a userform if pressed the key 'caps lock' is active and the key 'numlock' is active.
Is the function not active then I will hide the userform.
unfortunatly I don't now found a keyboard event in excel vba.
thanks.
Hello forumarbeit,
Welcome to the Forum!
Copy the macro code below into a VBA Module. You can then call the functions IsCapsLockOn and IsNumLockOn in your code to test the keys.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Leith thanks for your help,
but how can I recognize in all table sheets that a key was pressed?
this is my problem. Only then I can analyze the pressed keys from the keyboard.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks