KeyUp event

[FMadore]

In my VBA Excel application, I want to call a procedure when the user presses Ctrl-l. I know I have to do something like that but I don't know exactly how does it works.

private Sub oXLApp_KeyUp(byval KeyAscii as MSForms.ReturnInteger, byval Shift as Integer)
'MsgBox (KeyAscii & Shift)
End Sub




Could you please help me.

Thanks

[hoa01206]

Hi,

try this:

If KeyCode = vbKeyControl & Chr(KeyAscii)= "l" Then

do what you want here
End If

Good Luck!

Thanks
Hisham