I have figured out to accomplish this. Place the OnKey calls in the
beginning of the Worksheet_Activate and Worksheet_SelectionChange
subroutines. Then reset the OnKeys in the Worksheet_Deactivate and at the
end of the OnKey macros.

"joeeng" wrote:

The problem is that I only want this to trigger on one worksheet, and only if
the {ENTER} results in an intersection with particular cells. I can't see
how I can make the OnKey work for this circumstance. I might be missing
something though.

"Jim Thomlinson" wrote:

You can capture the key press of the enter key (note there are two enter
keys) something like this...

With Application
.OnKey "{Enter}", "MyMacro"
.OnKey "~", "MyMacro"
End With

The macro MyMacro will have to mimic a normal enter but that is just
seleting the cell you want... Check out this link...

http://msdn.microsoft.com/library/de...HV05203370.asp
--
HTH...

Jim Thomlinson


"joeeng" wrote:

How can I code vba to determine if the selection change on a worksheet was
the result of pressing the ENTER key?