Chris,

If I understand your question correctly, all you need to do go to the Tools
menu, choose Options then the Edit tab, and check the "Move selection after
Enter" setting, and set the direction setting to down. You can set this
with VBA with code like

Application.MoveAfterReturn = True
Application.MoveAfterReturnDirection = xlDown


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"cford31" wrote in message
...

I'm having a problem using offset with Worksheet_Change(). What I want
to accomplish is when the person finishes entering a value in the
current cell to move down one and to the left one.

Right now I have my code in the Worksheet_Change event but this makes
the active cell the next cell and then runs my code which offsets the
cell to the wrong cell.

All I want to do is make it easy for the user to enter data so that it
basically acts as a carriage return.

If you need more information let me know and I'll try to clarify
better.

Thanks,
Chris


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/