Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
go from one cell to another in excel
How do I go directly back to the next cell A from cell E, when tabbing?
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
go from one cell to another in excel
Hi Maggie,
I presume you mean to column A of the next row when tabbing from a cell in column E. Also assuming that mean there is nothing in Columns F through the end column (column IV). The following event macro can be installed by right click on the worksheet tab, view code, and copying in the following code. More information on Event Macros http://www.mvps.org/dmcritchie/excel/event.htm#ws_sc. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.column <= 5 then exit sub 'okay if A:E columns 1-5 On error resume next 'MUST reenable events... Application.EnableEvents = False ActiveCell.Offset(1, 1 - Target.Column).Select Application.EnableEvents = True End Sub---HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htmSearch Page: http://www.mvps.org/dmcritchie/excel/search.htm "Maggie Soto" <Maggie wrote in message ... How do I go directly back to the next cell A from cell E, when tabbing? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
go from one cell to another in excel
Maggie
Start in A1 and Tab across the E1. After typing something in E1 hit the ENTER key and you will go back to column A and down one to A2 There are other ways of using the Tab key to move through cells. See Bob Phillips' site for some of these. http://www.xldynamic.com/source/xld.xlFAQ0008.html There is another method using VBA with worksheet event code. Post back if you want to try that. Gord Dibben Excel MVP On Mon, 23 Jan 2006 09:11:03 -0800, "Maggie Soto" <Maggie wrote: How do I go directly back to the next cell A from cell E, when tabbing? Gord Dibben MS Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell on one page equals cell on another page in excel? | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
How Can I make a cell flash in Excel | Excel Discussion (Misc queries) | |||
Excel: how to formulate conditional cell references | Excel Worksheet Functions | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) |