Character count of a cell

Posted by Nishithraj under Others on 2/11/2010 | Views : 2318 | Status : [Member] | Replies : 4

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

I need to count the character entered in a cell of excel while typing itself(not moving out of the cell). If it reaches a certain amount of data I need to show the message to the user that he has typed these much of words.

I can use VBA for this. It can be possible only if we have key press event of a cell in excel. Any one has tried out this? If yes, please help me out...

Mark this as answer, if it is.....

With regards
Nishithraj Narayanan

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Sagarp on: 2/11/2010 [Member] Bronze

0	hi ref following link http://jsbi.blogspot.com/2007/04/excel-tip-how-to-perform-character.html http://support.microsoft.com/kb/187667 Thanks SagarP http://www.emanonsolutions.net http://emanonsolutions.blogspot.com/ Nishithraj, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Nishithraj on: 2/11/2010 [Member] Bronze

0	The links that you have provided explains about "how to count the characters in a cell", and this one I already knew. I need to show a message to the user while typing itself, if he/she crosses a limit of characters(say 900 characters). How can we do this? Even VBA code is acceptable. Mark this as answer, if it is..... With regards Nishithraj Narayanan Nishithraj, if this helps please login to Mark As Answer. \| Alert Moderator

The links that you have provided explains about "how to count the characters in a cell", and this one I already knew.

I need to show a message to the user while typing itself, if he/she crosses a limit of characters(say 900 characters). How can we do this?

Even VBA code is acceptable.

Mark this as answer, if it is.....

With regards
Nishithraj Narayanan

Nishithraj, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sagarp on: 2/11/2010 [Member] Bronze

0	Read following article http://www.tek-tips.com/viewthread.cfm?qid=560230&page=2 Thanks SagarP http://www.emanonsolutions.net http://emanonsolutions.blogspot.com/ Nishithraj, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Bubbly on: 2/16/2010 [Member] Bronze

0	Hello, Check this link http://www.ozgrid.com/forum/showthread.php?t=58820 Hope it helps ++ Thanks & Regards, Deepika Nishithraj, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts