Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Application.OnKey(Key, Procedure) "Hot Keys"

Status
Not open for further replies.
ByDesign

ByDesign

Electrical
Joined
Jun 3, 2003
Messages
17
Location
US
This is a great method... but of course I ran into some trouble.

Application.OnKey(Key, Procedure) sets up hotkeys, for example if you would like "Shift & Cntl & F" to run a sub you would code...

Application.OnKey "+^{k}, "MySub"

I'm using this to show and hide a form as needed.

It works great while excel is the active window... but when the Userform has focus the key combo is not recognized.

The code is currently in my workbook.open event I've tried placing it in the userform activate event as well... but no luck...

Any ideas???

Thanks for the help!!!

Have a great day!

Scott
 
Status
Not open for further replies.

Similar threads

Susangrizly
  • Locked
  • Question Question
How I circunavigated the problem with excel adding quotes to text
Replies
0
Views
788
Susangrizly
Susangrizly
MBD26
  • Locked
  • Question Question
ExcelVBA error: "License Not Found"
Replies
1
Views
511
Agent666
Agent666
nick262b
  • Locked
  • Question Question
Driving me insane " marks and Chr(34)
Replies
11
Views
697
CajunCenturion
CajunCenturion
alin09
  • Locked
  • Question Question
How to find a "word/string" in a text file if I don't use Cells of Excel
Replies
7
Views
337
loki3000
loki3000
HawksOkeyoJr
  • Locked
  • Question Question
modify formula Index Match in Macro to "go to next" if match not found
Replies
1
Views
191
chemebabak
chemebabak

Part and Inventory Search

Sponsor

Back
Top