Count Text Characters in cell

Hi all, I know that if you put formula "=LEN(A1)" in cell B1, it will
show the result of numbers of text characters been input in cell A1.
My question is that the result in cell B1 will appear only when you'll
put text in cell A1 and press Enter or Tab on your keyboard, but is it
possible or is there any simple way to see the result in cell B1 while
you are typing. Like if you putting text in cell A1 and the same time
you can see the numbers in cell B1 that how many text character you
have put in cell A1. If any friend have any suggestion or can help it
will be very helpful.

Technically, there is nothing in the cell until it is committed with ENTER,
TAB, etc.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"K" wrote in message
...
Hi all, I know that if you put formula "=LEN(A1)" in cell B1, it will
show the result of numbers of text characters been input in cell A1.
My question is that the result in cell B1 will appear only when you'll
put text in cell A1 and press Enter or Tab on your keyboard, but is it
possible or is there any simple way to see the result in cell B1 while
you are typing. Like if you putting text in cell A1 and the same time
you can see the numbers in cell B1 that how many text character you
have put in cell A1. If any friend have any suggestion or can help it
will be very helpful.

is it possible or is there any simple way to see
the result in cell B1 while you are typing.

No, that is not possible. When you're typing something in a cell Excel is in
edit mode and nothing can happen until Excel is out of edit mode. What that
means is until you're done typing and hit the enter key (or click the enter
icon on the formula bar, or tab, or the directional arrow keys) Excel can't
calculate how many characters you've typed.

--
Biff
Microsoft Excel MVP


"K" wrote in message
...
Hi all, I know that if you put formula "=LEN(A1)" in cell B1, it will
show the result of numbers of text characters been input in cell A1.
My question is that the result in cell B1 will appear only when you'll
put text in cell A1 and press Enter or Tab on your keyboard, but is it
possible or is there any simple way to see the result in cell B1 while
you are typing. Like if you putting text in cell A1 and the same time
you can see the numbers in cell B1 that how many text character you
have put in cell A1. If any friend have any suggestion or can help it
will be very helpful.

Hi,

Although you can't do this with a spreadsheet cell you can do this on a
userform which could then enter the data in the cell.

With a form containing a textbox and a label this would be the code

Private Sub TextBox1_Change()
Me.Label1 = Len(Me.TextBox1)
End Sub

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"K" wrote:

Hi all, I know that if you put formula "=LEN(A1)" in cell B1, it will
show the result of numbers of text characters been input in cell A1.
My question is that the result in cell B1 will appear only when you'll
put text in cell A1 and press Enter or Tab on your keyboard, but is it
possible or is there any simple way to see the result in cell B1 while
you are typing. Like if you putting text in cell A1 and the same time
you can see the numbers in cell B1 that how many text character you
have put in cell A1. If any friend have any suggestion or can help it
will be very helpful.