Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Aug 2002
    Location
    MN, USA
    Posts
    49
    Thanks
    0
    Thanked 0 Times in 0 Posts

    [arrow] as [tab] (2002)

    As I use the number pad a lot when entering data, I use the arrow key to move to the next cell to the right. When I'm ready for the next line, however, hitting the enter key will not start me in the first column again (like it would if I [tabbed] my way over). Is there a way to remap keys? Or maybe there is another simple solution (like a shortcut I don't know). I bet trying to fix this minor annoyance is more trouble than it is worth.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: [arrow] as [tab] (2002)

    Hit enter to move to next line
    Then <ctrl> + <left arrow> will get you to the first column

    If you want to remap the enter key use Application.onkey. Add this line to code to sheet activate or workbook open or some other event (or have a button to enable/disable it:

    <pre>application.OnKey "~", "FirstCol"</pre>


    Then have a routine in a module

    <pre>Sub FirstCol()
    ActiveCell.Offset(1, 0).End(xlToLeft).Select
    End Sub</pre>


    This will reset the enter key to normal operation:
    <pre>application.OnKey "~", ""</pre>


    You can remap any key (see application.onkey help for more info)
    Steve

  3. #3
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: [arrow] as [tab] (2002)

    Pressing the Home key should get you to the first column. HTH
    Gre

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: [arrow] as [tab] (2002)

    <img src=/S/doh.gif border=0 alt=doh width=15 height=15> Sometimes I forget the simplest things.

    Steve

  5. #5
    Lounger
    Join Date
    Aug 2002
    Location
    MN, USA
    Posts
    49
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: [arrow] as [tab] (2002)

    Thanks guys

Posting Permissions

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