return key...

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: return key...

  1. #1
    Board Regular
    Join Date
    Nov 2002
    Posts
    449
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default return key...

     
    hi
    Ive changed my settings so when press return (or enter) excel moves to cell to right instead of down..

    ive 2 columns (B & C)...ideally what i would like is something like

    enter details in B19, excel moves to right C19, excel then moves to B20, then to C20 etc

    is this possible?

    cheers all
    Andy

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: return key...

    Select columns B and C, and then, start entering the information.
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Posts
    2,314
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: return key...

    Right mouse over the sheet name (i.e. Sheet1) and select view code, then paste this in;

    Code:
    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Count > 1 Then Exit Sub
    If Target.Column = 3 Then Target.Offset(1, -1).Select
    
    End Sub

  4. #4
    Board Regular
    Join Date
    Nov 2002
    Posts
    449
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: return key...

    Hi Jimboy
    thanks for this...sorry am being a bit thick i think..ive done as you suggested but it doesnot seem to work...pressing enter, or return just moves cells to right each time...

    any ideas for me?
    thanks
    Andy

  5. #5
    Board Regular
    Join Date
    Apr 2002
    Posts
    2,314
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: return key...

    It will work when you change a cell in column C, if you what it to run when you change selection use this;

    Code:
    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Count > 1 Then Exit Sub
    If Target.Column = 4 Then Target.Offset(1, -2).Select
    
    End Sub

  6. #6
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: return key...

    Did you try what I suggested ??
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  7. #7
    Board Regular
    Join Date
    Nov 2002
    Posts
    449
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: return key...

    i did but i didnt put info in (Doh!) just pressed enter....
    thanks again, have great w/e
    Andy

  8. #8
    Board Regular Chitosunday's Avatar
    Join Date
    Jul 2003
    Posts
    1,017
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Private Sub Worksheet_Change(ByVal Target As Range)
    If ActiveCell.Column >= 4 Then
    Cells(ActiveCell.Row + 1, 2).Select
    end if
    End Sub
    Mr Young at Heart - Learning is like chasing the wind, it's boundless.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com