Responding to Enter Key
 

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

Responding to Enter Key
 

You can do this,

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

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

Regards,
Tom Ogilvy


"Don Guillett" wrote in message
...
use the worksheet_change event
if target.address < "$A:$1" then exit sub
call my procedure

--
Don Guillett
SalesAid Software
Granite Shoals, TX

"Charlie" wrote in message
...
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