Re: Can you limit the amount typed in a cell in Excel 2003?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

http://groups.google.com/group/microsoft.public.excel.programming/browse_frm/thread/d32aaa0f60a17bcf/4c949af9e8704188?lnk=st&q=Gary%27s+Student+group%3A*excel+bullen&rnum=1#4c949af9e8704188

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

.

Quantcast