key assignments

[Gary Keramidas]

is there a way to assign copy and paste to a function key or some other key
combination?

i tired this and it didn't work, it still bring up the help pane.

Application.OnKey "^{F1}", "^{C}"

 

[JE McGimpsey]

The second argument in Application.OnKey is the name of the macro you
want to run when the user presses the key in the first argument...

It doesn't allow you directly map one key onto another.

 

[Guest]

hi
this has been built in since before windows.... before the mouse.
ctrl + x = cut
crtl + c = copy
crtl + V = Paste
see this site for more keyboard shortcuts....
http://www.cpearson.com/excel/KeyboardShortcuts.htm

Regards
FSt1

 

[Guest]

Is there a method in VBA that allows each macro to be scanned to determine if
it has an OnKey assignment?

 

[Gary Keramidas]

i know that. i had a type. i don't want to use control f1, i just want to use f1

Application.OnKey "{F1}", "^{C}"

 

[Gary Keramidas]

thanks, wasn't sure about that.

--


Gary

The second argument in Application.OnKey is the name of the macro you
want to run when the user presses the key in the first argument...

It doesn't allow you directly map one key onto another.

 

[JE McGimpsey]

Not AFAIK.

 

[David McRitchie]

Getting Macro Short cut keys, by Ivan F Moala
"If you've ever wanted to get the short cut keys for your macros listed then here is an Addin that will help you get these."
http://www.xcelfiles.com/GetShortCutKeys.html

You might also be interested in
Shortcuts Found in Excel Menus
http://www.mvps.org/dmcritchie/excel/shortmenu.htm

Links to both of the above can be found on my page on shortcuts:
Shortcut Keys in Excel 2000 through Excel 2007
http://www.mvps.org/dmcritchie/excel/shortx2k.htm