Let's say I had a sheet of 10 columns and 10 rows. I begin entering data at A1 and tab through all 10 columns and don't want the next tab to put the cursor at column 11, I want it to go to the next line, A2, how would I do that?
Press Alt F11
Click on the 'ThisWorkbook' object of your spreadhseet.
Paste in the code
Save your spreadsheet
Activate cell A1
tab to the right, and
when you get to column K,
the cursor will drop down one row and go to column A.
'----- code starts below this line
Public sColumn As String
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, _
ByVal Target As Excel.Range)
' Code modified 09/03/2006 by Stanley D. Grom, Jr.
' Windows XP Professional SP2
' Excel 2003 SP2
sColumn = ActiveCell.Column
If sColumn = 11 Then