Results 1 to 9 of 9
  1. #1
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    386
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Cursor movements in excel 10

    I want the cursor to move to the right after each entry in a cell. That part I changed my options. Then like a typewriter, I would like the cursor to return to the original column but the next row down, automatically. Can I do this without a Macro. I thought if I protected the cells except for my entry cells area that this would work, but it doesn't.

    Thank you.

  2. #2
    2 Star Lounger AlanWade's Avatar
    Join Date
    Dec 2009
    Location
    Sweden
    Posts
    109
    Thanks
    12
    Thanked 3 Times in 3 Posts
    When you Protect your sheet uncheck the Select Locked Cells box or do you mean your active range is for example columns A to E and you want the next cell after E1 to be A2?
    Last edited by AlanWade; 2014-10-29 at 15:08.

  3. #3
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,637
    Thanks
    115
    Thanked 650 Times in 592 Posts
    MNN,

    There is no way without VBA to do what you are looking to do that I am aware of. Place the following code in your worksheet's module. In this example, when you enter data into a cell in columns A through H the active cell shifts to the right (as you set in options). If you entered data in a cell in column H, the active cell will shift down one row to the cell in column A like a typewriter as you described.

    Worksheet_Change Event:
    Code:
    Private Sub Worksheet_Change(ByVal Target As Range)
    'SHIFT TO NEXT ROW  AND COL A IF BEYOND COLUMN H
        If Intersect(Target, Range("A:G")) Is Nothing Then
            Cells(Target.Row + 1, 1).Select
        End If
    End Sub
    Use the following code instead if you want the typewriter effect and to prevent the user from selecting beyond col H

    Worksheet_SelectionChange Event:
    Code:
    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    'SHIFT TO NEXT ROW  AND COL A IF SELECTION BEYOND COLUMN H
        If Intersect(Target, Range("A:H")) Is Nothing Then
            Cells(Target.Row + 1, 1).Select
        End If
    End Sub
    HTH,
    Maud
    Last edited by Maudibe; 2014-10-29 at 23:15.

  4. #4
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    MNN,

    If you use the TAB key to "enter" your value the cell cursor will move to the right.
    Then when you have finished the entries for the row (tabbed to the next empty cell) press ENTER and you will return to Column A in the next row. HTH
    Last edited by RetiredGeek; 2014-10-30 at 07:14.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  5. #5
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,637
    Thanks
    115
    Thanked 650 Times in 592 Posts
    RG,

    That works only if you start in column A. If you start at D1, for example, then tab with entries, pressing enter will return you to D2 in column D where you started not A2.

    Maud

  6. #6
    Silver Lounger
    Join Date
    Mar 2014
    Location
    Forever West
    Posts
    2,072
    Thanks
    0
    Thanked 259 Times in 248 Posts
    Cursor movements in excel 10
    It might make a difference if knowing that Excel 2010 is actually version 14 [same for 2011 on Mac OS X]. Version 10 was released as Excel XP/2002. Changes made in each newer version can change how things happen or fail.

  7. #7
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,637
    Thanks
    115
    Thanked 650 Times in 592 Posts
    RG,

    Berton Makes a good point. Since you are running 2013, it may function differently for you than my 2010 version

  8. #8
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Maud,

    No, I'm running 2010. I've been using this trick for many many versions. I usually use it when I'm creating a database (table) and I guess I just always started in column A. I never thought of starting anywhere else. headbang.gif
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  9. #9
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,637
    Thanks
    115
    Thanked 650 Times in 592 Posts
    RG,

    Your method will also allow the user to keep tabbing across the sheet with no "automatic carriage return" at some point which is what I think MNN is trying to achieve hence, he tried protecting the cells. But I may be mistaken.

    Maud

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •