Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Input Order

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Fresno, CA USA
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have created a spreadsheet for a non-sophisticated group of users. This sheet requires the user to enter data into three cells, and then the desired result is calculated and displayed.

    Is there a function in Excel that is similar to Access in which you can set the order of input automatically for the user? (i.e., after input in A6, jump to B12, then to C6, and then return to A6)

    Thanks in advance,
    Tom

  2. #2
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try the following code in the module for your worksheet:

    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$A$6" Then
    [b12].Select
    ElseIf Target.Address = "$B$12" Then
    [c6].Select
    ElseIf Target.Address = "$C$6" Then
    [a6].Select
    End If
    End Sub
    Best regards,
    Allan Chara
    http://www.mrspreadsheets.com

  3. #3
    New Member
    Join Date
    Mar 2002
    Location
    Fresno, CA USA
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Al, Thanks for the tip. Sorry it's taken so long to get back. This code works great for the first two cells, but after entering data into the third cell it reverts to the default and advances down instead of back up to the first entry cell. Any ideas? As always thanks for such a prompt response.

  4. #4
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-01-14 15:42, TSpradling wrote:
    I have created a spreadsheet for a non-sophisticated group of users. This sheet requires the user to enter data into three cells, and then the desired result is calculated and displayed.

    Is there a function in Excel that is similar to Access in which you can set the order of input automatically for the user? (i.e., after input in A6, jump to B12, then to C6, and then return to A6)

    Thanks in advance,
    Tom
    I fy ou want a non-VBA solution, this is what you do ...

    1. Highlite the cells that need inputting by the user, and unprotect the cells.
    2. Protect the worksheet with or without a password.
    3. Now when the user enters the TAB key it takes the user from one unprotected cell to the next in order and then back to the starting unprotected cell.

    Hope This Helps!


    _________________
    Yogi Anand

    Edit: Deleted inactive website from hardcoded signature

    [ This Message was edited by: Yogi Anand on 2003-01-19 13:30 ]

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
  •