Limiting the number of characters in a cell. How?

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?

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)

<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
>
>

Thanks for the help guys Great!