I don't think I'd use this for what the OP wanted.

Gary''s Student wrote:

Here is an example from a post earlier this month. The routine is triggered
on a Selection Change:

http://groups.google.com/group/micro...949af9e8704188

I have coded other examples that allow the user to enter text in a cell and
have the status bar track the number of characters in the cell as they are
being entered.
--
Gary''s Student - gsnu200745

"Dave Peterson" wrote:

I don't think that this will work when the user is typing in a cell.



Gary''s Student wrote:

Hi Dave:

I was thinking of using Steve Bullen's CheckKey technique to read keyboard
strokes as they were being entered:

http://www.oaltd.co.uk/Excel/Default.htm
--
Gary''s Student - gsnu200745

"Dave Peterson" wrote:

I don't think that this will work.

Your macro won't work while the user is typing in a cell.

Maybe creating a userform and counting the characters would work for the OP,
though.

Gary''s Student wrote:

It is difficult because of fonts and font sizes. It is much easier to count
the characters as they are being typed and shift down once a limit has been
reached.
--
Gary''s Student - gsnu200745

"Rezzolve" wrote:

I have a template I have used for years but the problem is everytime you fill
the cell up you have to stop, go down to the next cell and continue. Is there
a way to make it auto enter to the next cell when the range you are typing in
is full?

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson