Add shortcut key or hot key via vba

  • Thread starter Thread starter Job
  • Start date Start date
J

Job

Anyone know how to programatically add hotkeys to existing subs via vba?
 
you could use the OnKey method eg.


application.OnKey "^{a}", "yoursub"

will assign the key shortcut crtl+a to the sub "yoursub"
 
Thanks Ben!
ben said:
you could use the OnKey method eg.


application.OnKey "^{a}", "yoursub"

will assign the key shortcut crtl+a to the sub "yoursub"
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

hot-key removal 3
Excel VBA 0
hot keys 5
Add ins not loading on existing workbooks 3
Calling Excel shortcuts from VBA 1
Accessing the AutoFilter method via VB.net 3
Shortcut key for add-in macro (Excel 2007) 8
Menus & Hot keys - works in Excel 2003 but not 2007 1

Back
Top