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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rezzolve - 17 Sep 2007 20:32 GMT

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?

Reply to this Message

Gary''s Student - 17 Sep 2007 20:50 GMT

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.

Signature

Gary''s Student - gsnu200745

> 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?

Reply to this Message

Dave Peterson - 17 Sep 2007 22:55 GMT

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.

> 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
[quoted text clipped - 6 lines]
> > a way to make it auto enter to the next cell when the range you are typing in
> > is full?

Signature

Dave Peterson

Reply to this Message

Gary''s Student - 18 Sep 2007 00:20 GMT

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

Signature

Gary''s Student - gsnu200745

> I don't think that this will work.
>
[quoted text clipped - 13 lines]
> > > a way to make it auto enter to the next cell when the range you are typing in
> > > is full?

Reply to this Message

Dave Peterson - 18 Sep 2007 00:48 GMT

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

> Hi Dave:
>
[quoted text clipped - 26 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message

Gary''s Student - 18 Sep 2007 01:28 GMT

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/thr
ead/d32aaa0f60a17bcf/4c949af9e8704188?lnk=st&q=Gary%27s+Student+group%3A*excel+b
ullen&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.

Signature

Gary''s Student - gsnu200745

> I don't think that this will work when the user is typing in a cell.
>
[quoted text clipped - 28 lines]
> > >
> > > Dave Peterson

Reply to this Message

Dave Peterson - 18 Sep 2007 04:06 GMT

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

> Here is an example from a post earlier this month. The routine is triggered
> on a Selection Change:
[quoted text clipped - 43 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message