Data Entry

  • Thread starter Thread starter John
  • Start date Start date
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,
 
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
 
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.
 
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...
 
Back
Top