We are trying to create a form that we have to take some of the infomation and paste it into another form that does not allow more than 100 characters. Is there a way to limit the number of characters in a cell with a message if it is exceeded without using macros?