Text box max length

E

eb1mom

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
 
R

raypayette

You could do this if you used a form to enter the data and ever
keystroke was monitored.
However the best you can do is to have this code in the sheet (o
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, th
excess of 255 characters will still be ignored and you won't be able t
edit that cell anymore!
Bad luck
 
Top