Another approach would be to create a Change event in the worksheet.
Here, check the Target.Address to see if the cell you're "watching" has
been changed.
if it is, then use "len(target.value)" to check the length of the
string.
If it is over the tested value, use msgbox to display a warning.

If this is the approach you would like, I can post some sample code.