Count Text Characters in cell

[K]

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.

 

[Shane Devenshire]

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