Input Order

[TSpradling]

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

 

[Al Chara]

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

 

[TSpradling]

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.

 

[Yogi Anand]

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