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

<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

Take a look at:

Data Validation

On the Settings Tab click on the "Allow:" drop down and choose Text
Length

Then go to the other tabs to set your message(s)


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=500673

Thanks for the help guys Great!


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