Navigation question for Excel97

Z

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. :)
 
C

CLR

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
 
G

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
 
Z

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
Click to expand...

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