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!


--
raypayette


------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=565026

Thank-you that will help me get things sorted out. eb1mom