Is it Possible

K

K

I have formula in cell B1 (see below)

=LEN(A1)

The problem is that I only see result in B1 when I enter text and
press Enter on keyboard. Is there way by macro or formula that I see
result in cell B1 or in anything else during typing text in cell A1.
normally this sort of function you see on Websites where you type in
textbox and on top it shows you how many text characters you have
entered. Basically i am creating an application form on excel and i
want user to see how many text characters he has put and i want him to
see this when he is typing, not when he press Enter on his keyboard
after typing. Please can any friend can help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count Text Characters in cell 1
Time Calculations Help 4
Conditional Formatting macro: simple, but doesn't work 6
Formula to calculate exact months and days between two dates 3
Concantenate which keeps bold of some parts. 5
Looking for a Date forming function 3
Naming non-contigent cells with vba 5
Using Text in a Formula or FormulaR1C1 property 3

Top