Re: $$Excel-Macros$$ Count characters in cell while typing

Hi , Try =LEN(cell) -- *Best Regards,* *Venkat* *Chennai* On Mon, Jul 25, 2011 at 5:53 PM, Ib Christian Bank < ib.christian.b...@gmail.com> wrote: > Hi > > I can't figure out how to make a macro that - while the user is typing > in a cell - automatically updates the statusbar with the current

Re: $$Excel-Macros$$ Count characters in cell while typing

use lan() formula On Mon, Jul 25, 2011 at 5:53 PM, Ib Christian Bank < ib.christian.b...@gmail.com> wrote: > Hi > > I can't figure out how to make a macro that - while the user is typing > in a cell - automatically updates the statusbar with the current > length of the cell. I'm not interested in

RE: $$Excel-Macros$$ Count characters in cell while typing

Count characters in cell while typing Hi I can't figure out how to make a macro that - while the user is typing in a cell - automatically updates the statusbar with the current length of the cell. I'm not interested in the event Worksheet_Change because it only fires when the user press

$$Excel-Macros$$ Count characters in cell while typing

Hi I can't figure out how to make a macro that - while the user is typing in a cell - automatically updates the statusbar with the current length of the cell. I'm not interested in the event Worksheet_Change because it only fires when the user press enter. Thanks --