You can't. keypress is not a detected event. While you are edidting the
contents of a cell no events are firing, so there is no way to do what you
want to do...
--
HTH...

Jim Thomlinson


"Jonathan Smith" wrote:

I need to find a way to do the following:

The user presses the "1" key in cell A1, without pressing enter, the active
cell changes to C1. Can anyone supply me with some sample code to do this.

THanks