Navigation question for Excel97

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

--
Zilbandy - Tucson, Arizona USA <zil@zilbandy.com.invalid>
Dead Suburban's Home Page: http://zilbandy.com/suburb/
PGP Public Key: http://zilbandy.com/pgpkey.htm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

CLR
Fri Sep 08 12:45:01 CDT 2006

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




"Zilbandy" wrote:

> 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. :)
>
> --
> Zilbandy - Tucson, Arizona USA <zil@zilbandy.com.invalid>
> Dead Suburban's Home Page: http://zilbandy.com/suburb/
> PGP Public Key: http://zilbandy.com/pgpkey.htm
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>

Gord
Fri Sep 08 15:02:09 CDT 2006

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



On Fri, 08 Sep 2006 10:17:58 -0700, Zilbandy <zil@zilbandy.com.invalid> wrote:

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

Zilbandy
Sat Sep 09 21:49:51 CDT 2006

On Fri, 08 Sep 2006 13:02:09 -0700, Gord Dibben <gorddibbATshawDOTca>
wrote:

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

--
Zilbandy - Tucson, Arizona USA <zil@zilbandy.com.invalid>
Dead Suburban's Home Page: http://zilbandy.com/suburb/
PGP Public Key: http://zilbandy.com/pgpkey.htm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~