Pressing Enter to skip rows

We have a pro-forma in Excel for clients. Anyway, the cells where they enter
information from a drop-down list are three rows apart, going down the page.

Is there anyway for the client to press Enter just once and go three rows
down rather than pressing enter three times?

I am aware that if the sheet is locked with the particular input cells
unlocked then Tab will take you to the next box however, we need Enter to do
the same.

I imagine a macro could achieve this.

Thanks in advance

i am sure there is a way that if enter is pressed it will offset the active down three rows, i unfortunately dont know this code howver i do know of one that does work

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address() = "$A$1" Then
Range("$C$1").Select 'move the cursor
End If
End Sub

so if your user inputs into cell d1 then pressing enter will got to d2 therefore adding this code and the range wanting to goto is D + 1 + 1 + 1 or D5

If Target.Address() = "$D$2" Then
Range("$D$5").Select 'move the cursor
End If

if you have millions this may take a while but still works great

thanks for the code however, I have tried this but whenever you click on the
cell eg. A1 then it automatically shifs to C1... it doesn't allow you to
enter anything in the cell before moving it straight to C1... do you know how
to code it such that when you have entered the data in the cell and press
ENTER it moves, and should only move when you press ENTER.

Cheers
Nick

"Zygan" wrote:

>
> i am sure there is a way that if enter is pressed it will offset the
> active down three rows, i unfortunately dont know this code howver i do
> know of one that does work
>
> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
> If Target.Address() = "$A$1" Then
> Range("$C$1").Select 'move the cursor
> End If
> End Sub
>
> so if your user inputs into cell d1 then pressing enter will got to d2
> therefore adding this code and the range wanting to goto is D + 1 + 1 +
> 1 or D5
>
> If Target.Address() = "$D$2" Then
> Range("$D$5").Select 'move the cursor
> End If
>
> if you have millions this may take a while but still works great
>
>
> --
> Zygan
> ------------------------------------------------------------------------
> Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423
> View this thread: http://www.excelforum.com/showthread...hreadid=549376
>
>

i mean if your user has to put a value in D1 then put the code to work for d2 so when the "user" presses enter to put in there data the activecell becomes d2 then it shift s

sorry for the late reply

i mean if your user has to put a value in D1 then put the code to work for d2 so when the "user" presses enter to put in there data the activecell becomes d2 then it shift s

sorry for the late reply