Cursor Go Home !!

[Lawrence Dodge]

Hi all--

Can anyone give me some advise on this. When I hit the Enter button, the cursor goes to the next row (that is good) but it doesn't go to the same column (that is bad); I would like it to go to the first column everytime without having to hit Home. Any thoughts ?

Thanks

LCD

 

[Luke M]

Hitting the Enter key should cause the cursor to do to one cell below unless 1 or more of following:


a) You've changed the default setting of which direction the cursor should go (Check under Tools - Options - Edit)

b) The worksheet is protected. In which case, it may just go to next unprotected cell

c) You previously hit the Tab key. In which case, it should go to 1 cell below the left most cell included in tab (so, shift-tabbing has no effect)


If you really want the cursor to always go to first column after changing something this macro will do it:

Private Sub Worksheet_Change(ByVal Target As Range)

Cells(Target.Row + 1, 1).Select

End Sub

But I'm not sure it's what you really want...

 

[Lawrence Dodge]

Thanks Luke -

Although the macro just made the cursor drop down on row; I figured out what I need to do. I need to use the tab button more and stop using the arrow keys.

Make yours a terrific day.

LCD