Redefining the Ctrl [ and Ctrl ]s short cut with OnKey?

[John Wirt]

I would like to assign subroutines to two key sequences, default Excel
shortcut key sequences: Ctrl [ and Ctrl ].

Is this possible?

I placed this code in the "ThisWorkbook" module of PERSONAL.xls and got this
error: "Method 'OnKey' object '_Application' failed.

-------
Option Explicit
Private Sub Workbook_Open()
Application.OnKey "^[", "FindLinkedCell"
Application.OnKey "^[", "ReturnToCell"
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.OnKey "^["
Application.OnKey "^]"
End Sub

 

[Ron de Bruin]

Hi John

Use this
Application.OnKey "^{[}", "FindLinkedCell"

 

[John Wirt]

Ron, Thank you. John

 

[John Wirt]

Unfortunately, this solution does not work (at least for me).

John

 

[Ron de Bruin]

Hi John

Do you see an error?

--
Regards Ron de Bruin
http://www.rondebruin.nl

Unfortunately, this solution does not work (at least for me).

John

Hi John

Use this
Application.OnKey "^{[}", "FindLinkedCell"

 

[John Wirt]

Yes, the error is: Method 'OnKey' of object '_Application' failed.


The code is (copied):

Private Sub Workbook_Open()
Application.OnKey "^([)", "FindLinkedCell"
Application.OnKey "^(])", "ReturnToCell"
End Sub

John

 

[Ron de Bruin]

Use a { and not a (



--
Regards Ron de Bruin
http://www.rondebruin.nl

Yes, the error is: Method 'OnKey' of object '_Application' failed.


The code is (copied):

Private Sub Workbook_Open()
Application.OnKey "^([)", "FindLinkedCell"
Application.OnKey "^(])", "ReturnToCell"
End Sub

John
----------------------------

Hi John

Do you see an error?