how do you say in VBA?

[Guest]

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

 

[Norman Jones]

Hi Spencer,

Look at the OnKey method in VBA help.

 

[Tom Ogilvy]

Look in Excel VBA help at the OnKey method.

 

[Charles Harmon]

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")

 

[Guest]

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

OnKey "1","MyMacro"

 

[Guest]

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?