Does anyone know of a way to count characters as they are entered into a cell? I want to display the 'characters left' from a limit of say 50, just like when writing a cell phone text message you get a count down from the 160 characters allowed (e.g. 80 entered out of 160 would be 80/160). I have tried data validation, but that only works after enter key pressed. Also worksheet_change event with len of cell value, same problem. I have searched extensively but cannot find a solution.
Things that happen on the Excel Sheet happen at the cell level either when you navigate into the cell or away from it.
However, you can probably use an excel form. Excel forms can capture data keystroke by keystroke. You would need a commit button to put the data back into the cell.
Or if you are interested in limiting the input to 50 characters, without keeping a running count, you can put a change event on the cell and use Target.Value = LEFT(Target.Value,50).
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
Thanks for responding dflak. I really want to keep a running count.
I guess I will have to use a userform. How would I capture the keystrokes in a TextBox?
Ok, just answered my own question, with a bit of research, using the Textbox_Change event
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks