Data Entry

J

John

I know that you can go to tools/options/edit to change the next cell after
you enter. I would like to go across the row instead of down the column.
Is there any way to make that selection just for a workbook, .

The change seems to be global until you change the preference again.

Thanks,
 
C

Cesar Zapata

one way is to add this code in your sheet code


Private Sub Worksheet_Change(ByVal Target As Range)
ActiveCell.Offset(-1, 1).Activate

End Sub


play with it.




Cesar Zapata
 
K

Ken Wright

In the ThisWorkbook Module:-

Private Sub Workbook_Open()
Application.MoveAfterReturnDirection = xlToRight
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.MoveAfterReturnDirection = xlDown
End Sub

This will change the setting to MoveRight when you open the workbook and to down
when you close it. If you only work on this workbook when it is open and not
any others then you'll have no problems doing what you want.
 
J

John

Thanks for the help with my project.

John

Ken Wright said:
In the ThisWorkbook Module:-

Private Sub Workbook_Open()
Application.MoveAfterReturnDirection = xlToRight
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.MoveAfterReturnDirection = xlDown
End Sub

This will change the setting to MoveRight when you open the workbook and to down
when you close it. If you only work on this workbook when it is open and not
any others then you'll have no problems doing what you want.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

-------------------------------------------------------------------------- --
It's easier to beg forgiveness than ask permission :)
-------------------------------------------------------------------------- --
Click to expand...
 
Top