After Max length in a cell is reached, is there anyway to make excel
automatically tab to the next cell down and allow data entry to continue?
Thanks
After Max length in a cell is reached, is there anyway to make excel
automatically tab to the next cell down and allow data entry to continue?
Thanks
You could do this if you used a form to enter the data and every keystroke was monitored.
However the best you can do is to have this code in the sheet (or worksheet)module:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
l = Len(ActiveCell.Text)
r = ActiveCell.Row
c = ActiveCell.Column
If l > 255 Then
Cells(r + 1, c).Select
End If
End Sub
Unfortunately the data has to be entered before changing cells, the excess of 255 characters will still be ignored and you won't be able to edit that cell anymore!
Bad luck!
Best regards,
Ray
Thank-you that will help me get things sorted out. eb1mom
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks