Shar

You must tell Excel you are ready to move to the next cell.

Enter, Tab, mouse click......your choice.

No way to just enter a number/letter and have Excel move out of the cell.

SelectionChange or Change Event code runs only on completion of the cell edit.


Gord Dibben Excel MVP

On Tue, 22 Nov 2005 17:53:11 +0000, Richard Buttrey
wrote:

On Tue, 22 Nov 2005 09:08:08 -0800, "Shar" <Shar
wrote:

I have a graph set up and would like the tab to automatically move to the
next cell after i type one number/letter in the cell. Is it possible to set
up this up in Excel?

Tools - Options - Edit tab - select the "Move selection after Enter"
option - choose the direction of travel to your next cell - OK

HTH

Richard Buttrey
__