top of page
John

Get a list of the keyboard shortcuts assigned to VBA macros in Excel

Specifically those keyboard shortcuts applied using the 'Macro Options' (Alt+F8) dialog and those applied using the Application.MacroOptions() method ... both of which, "under the hood", use the 'VB_ProcData.VB_Invoke_Func' Attribute (if you don't know what a VBA Attribute is, see my VBA Attributes post).


So just to be clear, this will not include keyboard shortcuts applied programmatically using the Application.OnKey() method.


Neither the VBE nor Excel itself will provide you with such a list. The only option is to export each standard Module to a text file then search through it for the Attribute (i.e. for "VB_ProcData.VB_Invoke_Func"). This isn't too bad if you only have 1 standard Module but becomes a bit dreary and error-prone if you have many.


So ... VBE_Extras to the rescue! Use the 'Keyboard shortcuts in this Project' command which identifies all such keyboard shortcuts across all standard Modules and provides you with a dialog such as:


List of keyboard shortcuts

0 comments

Recent Posts

See All

Comments


bottom of page