character limits

[cathlinn]

How can I set a character limit on a column and return an error message when
someone tries to go over the limit? I tried the prewritten script that was
recommended by Ronx in the Front Page postings:
7/26/2005 5:58 AM PST
Subject: Re: character counter script http://www.irt.org/script/1539.htm
In: microsoft.public.frontpage.programming
but I'm not much of a programmer and I couldn't translate it into visual
basic and make it work. What I need to do is set a 40 text character limit
on one column with 300 rows in all spreadsheets in a workbook. Is it
possible to do this? Thanks for any ideas.

 

[Tim Williams]

Data >> Validation >> Settings >> Allow >> Text length

Enter your limits and create a message to display when the entry is too
long.

Tim

 

[cathlinn]

Thanks Tim, I'll try it and let you know. Appreciate the help.

 

[stephifr]

Thanks! I have been looking everywhere to figure out how to do this.

Thanks so much!