Assign Shortcut keys within the VBE Window

excel, vba

Solution

Alternatively, if you want to do it using VBA you can do something like:

Sub SetShortcutKeys()
With Application
    .OnKey Key:="^+K", Procedure:="YourMacroGoesHere"
End With
End Sub

Problem

From the Excel Window, I can assign a shortcut key to my macro by: - going to the Developer tab - touching the Macros button - touching Options... in the resulting Dialog Box Can I assign this from within the VBE Window, using the VBE menu bar instead??

Original source