I would like to show in another cell the number of characters entered into a cell while editing this cell, that means before I press the <enter> key.
I would like to show in another cell the number of characters entered into a cell while editing this cell, that means before I press the <enter> key.
Not really possible in cells. When you open a cell for editing, it suspends all other activity in the sheet until you press ENTER, at which time any calculations in other cells would proceed.
I know it's not what you asked, but you could apply a Data Validation to that cell that only allows X characters total, and if they exceed that they would get an alert message when they pressed ENTER.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
LEN(A1) will deliver the length in character count of the string in cell A1.
It recalculates like all other functions, so it can't do this "automatic update" thing, either... maybe with VBA, but... probably not.
one workaround aside from data validation is think is vba but it goes like this..
create macro to show a form with textbox with a character counter....
if done typing the characters the value could be put in the selection cell.
some like
Please Login or Register to view this content.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Hi
Thank you very much for your help. How would I have to proceed if I want to continuously (while typing) show in cell B2 what is entered in cell in A2, that means without using the textbox function?
It's not possible. Excel doesn't recognize what is in the cell until you click enter or click on another cell.
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
Again, you can do this with a userform, just not an excel worksheet cell.
If this satisfies your question, then please mark the thread as Solved.
Good luck.
abousetta
Hello all,
Do any of you know if this had been addressed in the newest version of Excel? I have the same situation where it would be a "nice to know" how many characters have been typed into a cell that has a data validation set to accept a max of 20 characters. I've read the posts here but they're no longer current (<= 07-06-2012).
Thanks in advance for any help provided.
The status is the same as far as I know. An Excel "cell" is not like a "form field" and once you start to edit a cell all focus is set on that one cell and all activity elsewhere in the workbook is suspended.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks