Is there a way to display an active cell character count while the user is typing in a cell? I have limited a cell to 100 characters and would like to let the user know how close they are to the limit while they are typing.
Thanks.
JoJo
Is there a way to display an active cell character count while the user is typing in a cell? I have limited a cell to 100 characters and would like to let the user know how close they are to the limit while they are typing.
Thanks.
JoJo
Hello JoJo,
There is no built-in function in Excel to do that, and constructing a macro to do so would a very complicated task. Your users will just have to type until they stop typing or the cell Validation stops them.
Sincerely,
Leith Ross
This is how I would do it. Create a userform (showmodal=False). In this userform you have two textboxes and one label. The textboxes are small and covered by the label.
In the userform code sheetIn the code sheet for the worksheetPlease Login or Register to view this content.
When the user selects A1, Textbox1 is filled with the contents of A1. (But he doesn't see it, it's hidden by the label which shows the length of the string.)Please Login or Register to view this content.
As he types, his typing is reflected in A1, while the only thing he can see is the label, which continues to show the length. When he selects a different cell, the userform goes away. TextBox2 is there only so that when the user entere {Return} or {Tab} or {Enter} the focus has somewhere to go, so the TextBox1_Exit routine will run (Unload Me)
You'll need to modify the A1 restriction
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks