I need a Code or How to make it auto go to the next line down after 11
numbers are entered. In MS Excel.
I need a Code or How to make it auto go to the next line down after 11
numbers are entered. In MS Excel.
do you mean to say that you enter data in cols 1 to 11 ( A to K ) and after entering the data in last col K you want the cursor to go to col A of next row?
veerkar
If this is what you want enter the following sub for the sheet.
Private Sub Worksheet_Change(ByVal Target As Range)
Tcol = Target.Column
Trow = Target.Row
If Tcol = 11 Then Cells(Trow + 1, 1).Select
End Sub
To access the code page for the sheet, right click sheet name tab and click view code.
veerkar
Last edited by avveerkar; 04-01-2006 at 01:19 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks