Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Not Responding | Excel Discussion (Misc queries) | |||
Not responding...... | Excel Worksheet Functions | |||
why does it say not responding | New Users to Excel | |||
excel not responding | Excel Discussion (Misc queries) | |||
Excel is not responding. | New Users to Excel |