Cursor auto move from one cell to another

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


Using VBA how can I have my cursor automatically move from cell C9 to
cell A14 after hitting the enter key in cell B9? (note, there may be
data entered or else it may be left blank)

Then after enter data in A14, cursor movement go back to normal from
A14 (either right or down depending on the user settings).

Thanks all,

mikeburg


--
mikeburg
------------------------------------------------------------------------
mikeburg's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24581
View this thread: http://www.excelforum.com/showthread.php?threadid=399569

.

Relevant Pages