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

Data Validation Settings Allow Text length

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

Tim

--
Tim Williams
Palo Alto, CA


"cathlinn" wrote in message
...
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: 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.

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

"Tim Williams" wrote:

Data Validation Settings Allow Text length

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

Tim

--
Tim Williams
Palo Alto, CA


"cathlinn" wrote in message
...
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: 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.

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

Thanks so much!


--
stephifr
------------------------------------------------------------------------
stephifr's Profile: http://www.excelforum.com/member.php...o&userid=34195
View this thread: http://www.excelforum.com/showthread...hreadid=507516