software

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: www.excelforum.com/member.php...oamp;userid=25887
View this thread: www.excelforum.com/showthread...hreadid=500673lt;Datagt;lt;Validationgt;
In the quot;Allowquot; drop down choose quot;Text Lengthquot;
In the quot;Dataquot; drop down choose quot;Less than or equal toquot;
Enter 100 in the box

--
Regards,
Davequot;caliskierquot; wrote:

gt;
gt; We are trying to create a form that we have to take some of the
gt; infomation and paste it into another form that does not allow more than
gt; 100 characters. Is there a way to limit the number of characters in a
gt; cell with a message if it is exceeded without using macros?
gt;
gt;
gt; --
gt; caliskier
gt; ------------------------------------------------------------------------
gt; caliskier's Profile: www.excelforum.com/member.php...oamp;userid=25887
gt; View this thread: www.excelforum.com/showthread...hreadid=500673
gt;
gt;


Take a look at:

Data gt; Validation

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

Then go to the other tabs to set your message(s)--
Cutter
------------------------------------------------------------------------
Cutter's Profile: www.excelforum.com/member.php...foamp;userid=9848
View this thread: www.excelforum.com/showthread...hreadid=500673
Thanks for the help guys Great!--
caliskier
------------------------------------------------------------------------
caliskier's Profile: www.excelforum.com/member.php...oamp;userid=25887
View this thread: www.excelforum.com/showthread...hreadid=500673