Limiting the number of characters in a cell. How?

[caliskier]

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?

 

[Guest]

<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

 

[Cutter]

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)

 

[caliskier]

Thanks for the help guys Great!