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

It is possible. You can adapt Bullen's CheckKey routine available in:

http://www.oaltd.co.uk/Excel/Default.htm
--
Gary''s Student - gsnu200825


"K" wrote:

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