Navigation question for Excel97

[Zilbandy]

I have my spreadsheet set up to move one cell to the right when I hit
'Enter'. What I would like to do is as follows: On entering column F,
I want the cursor to move to column A of the next row. Thanks.

 

[Guest]

This Change-event macro should do it for you.........

Private Sub Worksheet_Change(ByVal Target As Range)
'Macro returns cursor to column A one row down after
'entry in column F
ActiveCell.Select
If ActiveCell.Column = 7 Then
If Not Selection Is Nothing Then
Application.Selection.Offset(1, -6).Select
End If
Else
End If
End Sub

Vaya con Dios,
Chuck, CABGx3

 

[Gord Dibben]

Change the ENTER key to move down when hit.

Then.............Starting in A1 use the Tab key to move right one cell at a
time.

When leaving F1 hit the ENTER key to go back to A2


Gord Dibben MS Excel MVP

 

[Zilbandy]

Change the ENTER key to move down when hit.

Then.............Starting in A1 use the Tab key to move right one cell at a
time.

When leaving F1 hit the ENTER key to go back to A2


Gord Dibben MS Excel MVP

That'll work, since my knowledge of macros is non existent.