Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Force Tab
I am working in Excel 2002.
Currently I have a table (A1:U14), is there any way that I can apply coding to a column, in this case, column U, so when I tab out of cell U14 the cursor will go to the beginning of that row, cell A14. Or to the beginning of whatever row I may be tabbing out of in column U. -- Jamie |
#2
|
|||
|
|||
I assume you are tabbing out of the U cell after you entered something in
that cell. If so, then a Worksheet_Change event macro will work for you. Something like: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 21 Then _ Cells(Target.Row, 1).Select End Sub HTH Otto "Jamie" wrote in message ... I am working in Excel 2002. Currently I have a table (A1:U14), is there any way that I can apply coding to a column, in this case, column U, so when I tab out of cell U14 the cursor will go to the beginning of that row, cell A14. Or to the beginning of whatever row I may be tabbing out of in column U. -- Jamie |
#3
|
|||
|
|||
Thanks for the coding. Excuse my inexperience, I'm assuming I enter this
coding by creating a new macro, but how do I get it to run? "Otto Moehrbach" wrote: I assume you are tabbing out of the U cell after you entered something in that cell. If so, then a Worksheet_Change event macro will work for you. Something like: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 21 Then _ Cells(Target.Row, 1).Select End Sub HTH Otto "Jamie" wrote in message ... I am working in Excel 2002. Currently I have a table (A1:U14), is there any way that I can apply coding to a column, in this case, column U, so when I tab out of cell U14 the cursor will go to the beginning of that row, cell A14. Or to the beginning of whatever row I may be tabbing out of in column U. -- Jamie |
#4
|
|||
|
|||
Jamie
Copy Otto's code which is worksheet event code and goes into the sheet module. Right-click on the worksheet tab and "View Code". Paste in there. You do not "run" it. The Change_Event runs itself whenever you TAB or ENTER out of a cell in Column U after you have entered data. Gord Dibben Excel MVP On Tue, 1 Feb 2005 14:23:05 -0800, "Jamie" wrote: Thanks for the coding. Excuse my inexperience, I'm assuming I enter this coding by creating a new macro, but how do I get it to run? "Otto Moehrbach" wrote: I assume you are tabbing out of the U cell after you entered something in that cell. If so, then a Worksheet_Change event macro will work for you. Something like: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 21 Then _ Cells(Target.Row, 1).Select End Sub HTH Otto "Jamie" wrote in message ... I am working in Excel 2002. Currently I have a table (A1:U14), is there any way that I can apply coding to a column, in this case, column U, so when I tab out of cell U14 the cursor will go to the beginning of that row, cell A14. Or to the beginning of whatever row I may be tabbing out of in column U. -- Jamie |
#5
|
|||
|
|||
Thanks Gord. I should have included that but I was rushed at the moment.
Otto "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Jamie Copy Otto's code which is worksheet event code and goes into the sheet module. Right-click on the worksheet tab and "View Code". Paste in there. You do not "run" it. The Change_Event runs itself whenever you TAB or ENTER out of a cell in Column U after you have entered data. Gord Dibben Excel MVP On Tue, 1 Feb 2005 14:23:05 -0800, "Jamie" wrote: Thanks for the coding. Excuse my inexperience, I'm assuming I enter this coding by creating a new macro, but how do I get it to run? "Otto Moehrbach" wrote: I assume you are tabbing out of the U cell after you entered something in that cell. If so, then a Worksheet_Change event macro will work for you. Something like: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 21 Then _ Cells(Target.Row, 1).Select End Sub HTH Otto "Jamie" wrote in message ... I am working in Excel 2002. Currently I have a table (A1:U14), is there any way that I can apply coding to a column, in this case, column U, so when I tab out of cell U14 the cursor will go to the beginning of that row, cell A14. Or to the beginning of whatever row I may be tabbing out of in column U. -- Jamie |
#6
|
|||
|
|||
Gord and Otto: Thank you, thank you, thank you. It works like a charm. You
are awesome!! "Gord Dibben" wrote: Jamie Copy Otto's code which is worksheet event code and goes into the sheet module. Right-click on the worksheet tab and "View Code". Paste in there. You do not "run" it. The Change_Event runs itself whenever you TAB or ENTER out of a cell in Column U after you have entered data. Gord Dibben Excel MVP On Tue, 1 Feb 2005 14:23:05 -0800, "Jamie" wrote: Thanks for the coding. Excuse my inexperience, I'm assuming I enter this coding by creating a new macro, but how do I get it to run? "Otto Moehrbach" wrote: I assume you are tabbing out of the U cell after you entered something in that cell. If so, then a Worksheet_Change event macro will work for you. Something like: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 21 Then _ Cells(Target.Row, 1).Select End Sub HTH Otto "Jamie" wrote in message ... I am working in Excel 2002. Currently I have a table (A1:U14), is there any way that I can apply coding to a column, in this case, column U, so when I tab out of cell U14 the cursor will go to the beginning of that row, cell A14. Or to the beginning of whatever row I may be tabbing out of in column U. -- Jamie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel save as csv - force text qualifier on every text field | Excel Discussion (Misc queries) | |||
How to force continuous lines in line charts | Charts and Charting in Excel | |||
Force save as | Excel Discussion (Misc queries) | |||
How do I force a series in a Bar-Line Chart to be a Bar? | Charts and Charting in Excel | |||
How do I force a hyperlink in a spreadsheet to open a new window? | Excel Worksheet Functions |