Hi Folks!

This is based on another post in the .misc group that I
was involved in earlier today. It was about limiting the
number of characters that can be entered into a cell.

Anyhow, what I would like is to have the number of
characters counted as they are being typed. Is that
possible?

For example, A1 is to be filled in by the user. The max
number of characters permitted is 50. Can cell B1 be used
as an accumulator as the user types in cell A1? This way
the user can see how many characters they have typed and
how many more they can continue to type.

Biff

Hi Biff,

As far as I know there isn't any way to do this. While you are in the
process of entering data into a cell, Excel is in a state called edit mode
in which it is only responsive to the keyboard and the mouse. No other cells
and no VBA code have any idea what's going on during edit mode. They have to
wait until it's completed and work with the end result.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"Biff" wrote in message
...
Hi Folks!

This is based on another post in the .misc group that I
was involved in earlier today. It was about limiting the
number of characters that can be entered into a cell.

Anyhow, what I would like is to have the number of
characters counted as they are being typed. Is that
possible?

For example, A1 is to be filled in by the user. The max
number of characters permitted is 50. Can cell B1 be used
as an accumulator as the user types in cell A1? This way
the user can see how many characters they have typed and
how many more they can continue to type.

Biff

Thanks Rob, I had my doubts!

I've seen this feature on web pages, but then, they
weren't written in VBA!

Biff

-----Original Message-----
Hi Biff,

As far as I know there isn't any way to do this.
While you are in the
process of entering data into a cell, Excel is in a state
called edit mode
in which it is only responsive to the keyboard and the
mouse. No other cells
and no VBA code have any idea what's going on during edit
mode. They have to
wait until it's completed and work with the end result.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"Biff" wrote in message
...
Hi Folks!

This is based on another post in the .misc group that I
was involved in earlier today. It was about limiting the
number of characters that can be entered into a cell.

Anyhow, what I would like is to have the number of
characters counted as they are being typed. Is that
possible?

For example, A1 is to be filled in by the user. The max
number of characters permitted is 50. Can cell B1 be
used
as an accumulator as the user types in cell A1? This way
the user can see how many characters they have typed and
how many more they can continue to type.

Biff


.