Not sure if this is possible..........
I have merged cells B23:H38 in order that users can type data into it. I understand that the maximum number of characters that can be viewed is 1024.
I would like a counter to countdown the number of characters that can be entered as the user is typing. I've used this formula in cell B22 =1024 - LEN(B23). The only problem is that it only shows the value when the entry is made. I need it so that it reduces as the characters are being typed.
I have merged cells B23:H38 in order that users can type data into it. I understand that the maximum number of characters that can be viewed is 1024.
I would like a counter to countdown the number of characters that can be entered as the user is typing. I've used this formula in cell B22 =1024 - LEN(B23). The only problem is that it only shows the value when the entry is made. I need it so that it reduces as the characters are being typed.
