Macro Shortcut Key Assignments Excel 2010

[darchambault1]

I have several, probably more than 10 shortcut keys assigned to my macros. I know I can open each macro and check options to see which key I have assigned, but is there a property in VBE that will tell me which, if any, shortcut key I assigned to a macro? Or is there any handy code that someone has available to help me more easily identify which keys I have assigned already?

 

[Logit]

.
You can review this resource : Excel VBA to list key bindings (OnKey ?) - Stack Overflow

You can also use the VBE word search tool: VBE / EDIT / FIND and have it look for "Application.OnKey "

 

[RoryA]

If you assigned the shortcut keys using the macros dialog, you can only export the module and read through it to find the shortcut keys. They aren't exposed through any property in VBA.

 

[darchambault1]

Great info. I never knew or thought to look into the onkey info. Thanks!

 

[Logit]

You're welcome.