total characters in a cell

[talytech]

Is there a way to return the total characters typed in a cell in another cell, as the end-user is typing in the cell. For example: I want the end-user to see the total characters count up as he/she types in the cell.

The way I do it in Access is like this:
somevariable = len([field].text)

[Bob Phillips]

Excel can count in the same way, but not as they are typing, after they hit Enter.