how do you say in VBA?
 

in VBA how do you say, "If the #1 key is pressed then, RUNMACRO"?

how do you say in VBA?
 

Hi Spencer,

Look at the OnKey method in VBA help.

---
Regards,
Norman



"Spencer Hutton" wrote in message
...
in VBA how do you say, "If the #1 key is pressed then, RUNMACRO"?

how do you say in VBA?
 

Look in Excel VBA help at the OnKey method.

--
Regards,
Tom Ogilvy


"Spencer Hutton" wrote in message
...
in VBA how do you say, "If the #1 key is pressed then, RUNMACRO"?

how do you say in VBA?
 

Hi,
If your trying to set a key to run a Macro. Select "Tool" then select
"Macro" Then select "Macro" a list of macro's should be displayed. select
which macro you want to run then select the "Option's" and assign it to a
key (Alpha). click OK. then close out. When you want to run the Macro you
can press "Cntl" and "q" this will excute the Macro.(assumed you assigned
"q")


"Spencer Hutton" wrote in message
...
in VBA how do you say, "If the #1 key is pressed then, RUNMACRO"?

how do you say in VBA?
 

OnKey will do what you want - see VBA help for details

OnKey "1","MyMacro"


"Spencer Hutton" wrote:

in VBA how do you say, "If the #1 key is pressed then, RUNMACRO"?

how do you say in VBA?
 

Great it works, but how does excel tell the difference between the number one
above the keys, and the number one on the numeric keypad?

"Tom Ogilvy" wrote:

Look in Excel VBA help at the OnKey method.

--
Regards,
Tom Ogilvy


"Spencer Hutton" wrote in message
...
in VBA how do you say, "If the #1 key is pressed then, RUNMACRO"?