Responding to Enter Key

[Charlie]

Hi

Is it possible to start a procedure running whenever enter is hit on a
particular worksheet cell? Obviously I can react to a double click through
the worksheet double click event but is there a "on key" event equivalent?

Thanks

Charlie

 

[Tom Ogilvy]

You can do this,

Sub SetEnter()
Application.OnKey "~", "mymacro"
End Sub

Sub ClearEnter()
Application.OnKey "~"
End Sub

Regards,
Tom Ogilvy