Pressing Enter to skip rows

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

NICK - 07 Jun 2006 09:48 GMT

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

Reply to this Message

Zygan - 07 Jun 2006 11:27 GMT

i am sure there is a way that if enter is pressed it will offset th
active down three rows, i unfortunately dont know this code howver i d
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 d
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 grea

Reply to this Message

NICK - 08 Jun 2006 00:50 GMT

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

> 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
[quoted text clipped - 15 lines]
>
> if you have millions this may take a while but still works great

Reply to this Message

Zygan - 09 Jun 2006 11:10 GMT

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

sorry for the late repl

Reply to this Message

Zygan - 09 Jun 2006 11:10 GMT

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

sorry for the late repl

Reply to this Message