This is what I am trying to do:

For a given cell in column B I want to make a manual entry, e.g., in B10.
When I press return I want a VBA routine to run that will enter information
into the adjacent cell in column A, A10 in this case. KeyPress function
does not respond to the "event" of return being pressed. Is there a way to
detect the return or "Enter" key being pressed?

Thanks.

Thomas