Software

Ask something
Discussion Locked

actions in excel

0 helpful
4 replies

by mckay_mark

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a worksheet that I'm using in excel that I want to move from one cell to another 3 columns down after the enter key is pressed. Is this possible? If so...how would I go about it? I know nothing about macros or VB.

4 replies

by dklippert

There are a couple of "non-macro" ways to do this.
If you choose the data entry cells and then go to Format>Cells Protection and remove the chewck mark from Locked. You can now go to Tools>Protection and protect the sheet. Now when you press the tab key you will jump to the next un locked cell.
Another way would be to select the data entry cells and Go to Insert>Names Define and give the range a name.
You can now use Edit>Goto to select the range. Now when you hit the Enter key it will jump to the next cell in the range.

by dklippert

Here's a tiny macro way to do it.
Each time you make an entry and hit the enter key, the selection will go down 3 rows. An entry has to be made.
Right click the Worksheet tab and choose View code.
Paste this code in the editor:

Private Sub Worksheet_Change(ByVal Target As Range)
Target.Offset(3).Select
End Sub

This discussion is closed to new replies.