How do I go directly back to the next cell A from cell E, when tabbing?
How do I go directly back to the next cell A from cell E, when tabbing?
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 [email protected]> wrote in message news:[email protected]...
> How do I go directly back to the next cell A from cell E, when tabbing?
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
[email protected]> wrote:
>How do I go directly back to the next cell A from cell E, when tabbing?
Gord Dibben MS Excel MVP
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks