Solved: Detect key press in document using vba

[Carsten]

Hi

How can I detect when a user press the F4 button in a document

I want to show the user a message when he/she hit F4

Best Regards
Carsten

[Paul_Hossler]

In a standard module, just add your own EditRedoOrRepeat sub


Option Explicit
Sub EditRedoOrRepeat()

MsgBox "Add your message here"
End Sub


That works until someone changes the key-to-command customizations

I have 2007, but back saved to 2003 so it 'should' work

Paul

[Carsten]

Hi Paul

Thanks, it works perfect :hi:

Carsten

[Paul_Hossler]

Good.

Excel has a much more robust .Onkey that Word does

Don't forget to mark your thread 'Solved' using 'Thread Tools' at the top

Paul

[Carsten]

Thanks again

Carsten