ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   dynamic character counter for merged cell text field (https://www.excelbanter.com/excel-worksheet-functions/156315-dynamic-character-counter-merged-cell-text-field.html)

JASelep

dynamic character counter for merged cell text field
 
would like to display countdown of characters typed into merged text cell so
users can see how much more room they have to answer
--
Jim

T. Valko

dynamic character counter for merged cell text field
 
Not possible.

While you're typing data in a cell Excel is in edit mode. No events can take
place until your're out of edit mode. In this case the event would be the
calculation of a formula that returns the number of characters entered into
a cell.

--
Biff
Microsoft Excel MVP


"JASelep" wrote in message
...
would like to display countdown of characters typed into merged text cell
so
users can see how much more room they have to answer
--
Jim





All times are GMT +1. The time now is 01:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com