Data Entry Macro

[Couter]

I have a question that I am pretty sure has been answered before. I am entering data in a spreadsheet and want to minimize the number of keystrokes. Now here is my problem:
After I enter the data in cell G6, I want the selection to automatically go to cell A7. What kind of macro do I need to put there?

 

[Asala42]

G'day,

You could actually use Sheet Protection to do this. The steps are:

Highlight the data entry range (columns A-G). Format cells, Protection tab, then unlock the cells. Then when you get into a data entry mood go to tools/protection/protect sheet (defaults).

While the sheet is protected you can only enter data into unlocked cells. The good part is that you can quickly move through the cells by hitting TAB to move to the right or to a new record.

Hope that helps,
Adam

 

[Tom Urtis]

Another option is to use this code in your worksheet module (right click on sheet tab, left click on View Code, and paste this in):

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> "$G$6" Then Exit Sub
[A7].Select
End Sub