Responding to Enter Key

  • Thread starter Thread starter Charlie
  • Start date Start date
C

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
 
You can do this,

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

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

Regards,
Tom Ogilvy
 
Back
Top