hey thr,

Private Sub Workbook_Open()
MsgBox "open"
Application.OnKey "{~}", "EnterKey"
End Sub
Sub EnterKey()
MsgBox "enter key"
Call ActiveCell.Offset(ActiveSheet.Target.Row + 1,
ActiveSheet.Target.Column)
End Sub

in the above code, enterkey is not being invoked. where should the
application.onKey assignment be done.

appreciate your inputs.

thanks

"Ronbo" wrote:

Got it. Alt=%

"Ronbo" wrote:

What is the correct syntax for;

Application.OnKey "Alt{F8}", ""?

I need to know the syntax for adding the alt to the f8. If I use
(Application.OnKey "{F8}", "") it works, but I don't know how to get (Alt +
F8).

Thanks for any help.