ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Assign subroutine to a key press?? (https://www.excelbanter.com/excel-programming/444059-assign-subroutine-key-press.html)

Robert Crandal[_2_]

Assign subroutine to a key press??
 
I have a subroutine named "DoCalculation" which I would
like to be called when a user presses Ctrl-D. What are
ALL the possible ways to assign a key press to a subroutine
of my choosing?

Thanks!



Anthony[_18_]

Assign subroutine to a key press??
 
?"Robert Crandal" wrote in message
...

I have a subroutine named "DoCalculation" which I would
like to be called when a user presses Ctrl-D. What are
ALL the possible ways to assign a key press to a subroutine
of my choosing?

Thanks!

try;

application.onkey("^{d}"), docalculation

you might need to check the onkey syntax, but the basics are there.

Regards

Anthony



All times are GMT +1. The time now is 08:23 PM.

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