Correct Syntax

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ronbo - 28 Dec 2005 03:33 GMT

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.

Reply to this Message

Ronbo - 28 Dec 2005 04:07 GMT

Got it. Alt=%

> What is the correct syntax for;
>
[quoted text clipped - 5 lines]
>
> Thanks for any help.

Reply to this Message

SKRS - 21 Feb 2006 13:57 GMT

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

> Got it. Alt=%
>
[quoted text clipped - 7 lines]
> >
> > Thanks for any help.

Reply to this Message