On Dec 10, 1:03*pm, Gord Dibben <gorddibbATshawDOTca wrote:
Type onkey into the help diaolog when in the VBE

All combos are listed with usage instructions and examples

Gord Dibben *MS Excel MVP

On Wed, 10 Dec 2008 07:50:57 -0800 (PST), cass calculator

wrote:
Could you please show me a simple example for how to use the OnKey
method for combinations of ctrl, shift and alt?

Thanks,

Joshua

As an example, I have the following code that highlights all the
precedents of a selection, and I'd like to assign it to the shortcut
Ctrl + Shift + J

Sub HighlightPrecedents()
Dim rngCell As Range
For Each rngCell In Selection
rngCell.ShowPrecedents
Next rngCell
End Sub

Where do I put the following code?

Application.OnKey "^+{J}, "HighlightPrecedents"