Pressing Enter to skip rows


G

Guest

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
 
Ad

Advertisements

Z

Zygan

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
 
G

Guest

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
 
Z

Zygan

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
 
Ad

Advertisements

Z

Zygan

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top