Cursor Movement when hitting "Enter"

How do I change where the cursor moves when I hit "Enter"?
Who is Participating?
Rory ArchibaldConnect With a Mentor Commented:
Not complicated really - you'd need a worksheet activate event and a selection change one - something like the code below.
FYI, down IS the standard.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Not Intersect(Target, rnage("A:A")) Is Nothing Then
        Application.MoveAfterReturnDirection = xlDown
        Application.MoveAfterReturnDirection = xlRight
    End If
End Sub

Open in new window

Rory ArchibaldCommented:
In 2003 and prior: Tools-Options-Edit tab.
In 2007: Office button-Excel options-Advanced section, first option.
I don't which Office version you are using, but I'm going to answer for Excel 2007.

Go to 'Office button' and click 'Excel options' button (right bottom corner). A new window will be opened.
Click on 'Advanced' and you will see a list of checkboxs, and the first one says 'After pushing Enter, move selection'. The you can choose the direction.

Excuse me if the messages aren't exactly real, but I have Spanish version.
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Bright01Author Commented:
Rorya and siys23,
I only want the cursor to move down in one section of the sheet while keeping the cursor "standard" in the rest of the sheet.  Can I control the cursor at the cell level?
Rory ArchibaldCommented:
Only with code, if that's an option. (we'd need to know which ranges)
Bright01Author Commented:
Is it simple (a few lines) or a major undertaking?  I can plug in the range and then replicate as necessary thoughout the sheet.
If difficult, I'll close out the question with the answers I have.
Bright01Author Commented:
Thank you!  Very helpful.......
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.