It should do that automatically if under tools=Options=Edit tab, you
haven't unchecked "move selection after enter"

--
Regards,
Tom Ogilvy


"Don" wrote:

I use Excel but never program in it. However, I use VBA in Microsoft Access
a lot.

Can someone get me started and tell me the syntax to program a spreadsheet
to move the focus from one cell to another once something is entered into the
first cell? Thanks in advance.
--
Don Rountree