 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / September 2006Navigation 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. :)  SignatureZilbandy - Tucson, Arizona USA <zil@zilbandy.com.invalid> Dead Suburban's Home Page: http://zilbandy.com/suburb/ PGP Public Key: http://zilbandy.com/pgpkey.htm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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 > 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. :) 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 >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. :) >Change the ENTER key to move down when hit. > [quoted text clipped - 4 lines] > >Gord Dibben MS Excel MVP That'll work, since my knowledge of macros is non existent. :) SignatureZilbandy - Tucson, Arizona USA <zil@zilbandy.com.invalid> Dead Suburban's Home Page: http://zilbandy.com/suburb/ PGP Public Key: http://zilbandy.com/pgpkey.htm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.