<Data<Validation
In the "Allow" drop down choose "Text Length"
In the "Data" drop down choose "Less than or equal to"
Enter 100 in the box

--
Regards,
Dave


"caliskier" wrote:


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?


--
caliskier
------------------------------------------------------------------------
caliskier's Profile: http://www.excelforum.com/member.php...o&userid=25887
View this thread: http://www.excelforum.com/showthread...hreadid=500673