Data Entry Macro

Couter · May 6th, 2002, 07:00 AM

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 · May 6th, 2002, 07:22 AM

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 · May 7th, 2002, 07:12 AM

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

May 7th, 2002, 07:12 AM	#3
Tom Urtis MrExcel MVP Join Date: Feb 2002 Location: San Francisco, California USA Posts: 10,387	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 __________________ Tom Urtis Microsoft MVP - Excel

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 6th, 2002, 07:00 AM	#1
Couter New Member Join Date: May 2002 Posts: 3	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?

May 6th, 2002, 07:22 AM	#2
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,027	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