Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: change keyboard responses in excel

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a protected worksheet. To get around in the worksheet I need to use the tab key. The people that use the spread sheet always hit the "enter" key, which drop down one cell. I would like to change the "enter" key response to "tab" on open. It must be through ascii but I cannot figure it out. I sure can use your help.

  2. #2
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    It must be through ascii but I cannot figure it out. I sure can use your help.
    I don't understand what you mean by "It must be through ascii", but you can change the direction of the cursor when you hit "ENTER" by going to Tools|Option|Edit TAB and make sure the "Move Direction After Enter" box is checked, then change the "Direction" dropdown box to "Right"

    HTH

  3. #3
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Say the fields they enter in are $A$1 $C$1 $E$1 $A$4 $B$6 in that order. This code will move the selection to the next fieldwhen Enter is keyed
    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address=($A$1) Then Range($C$1).Select
    If Target.Address=("$C$1) Then Range($E$1).Select
    etc.



    End Sub

  4. #4
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If you must change it then lookup online
    help for OnKey....you can change the enter
    key to Tab using code.
    Kind Regards,
    Ivan F Moala From the City of Sails

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    see:

    http://www.mrexcel.com/board/viewtop...c=5982&forum=2

    Should give you what you need

    Tom

Some videos you may like

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
  •