Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count Words in a Textbox
Hi, I would like to count the number of words in a textbox (Comments) (Forms) and display it in another textbox (WC) (wordcount should be dynamic - as the user keeps typing, result should get updated) Girish:) -- Baapi ------------------------------------------------------------------------ Baapi's Profile: http://www.excelforum.com/member.php...o&userid=27333 View this thread: http://www.excelforum.com/showthread...hreadid=560506 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count Words in a Textbox
Private Sub Textbox1_Change()
Dim numwords as Long numwords = Len(Textbox1.Text) - len(replace(Application.Trim(Textbox1.Text)," ","")) + 1 Textbox2.Text = numWords End Sub -- Regards, Tom Ogilvy "Baapi" wrote in message ... Hi, I would like to count the number of words in a textbox (Comments) (Forms) and display it in another textbox (WC) (wordcount should be dynamic - as the user keeps typing, result should get updated) Girish:) -- Baapi ------------------------------------------------------------------------ Baapi's Profile: http://www.excelforum.com/member.php...o&userid=27333 View this thread: http://www.excelforum.com/showthread...hreadid=560506 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count the words in a cell | Excel Worksheet Functions | |||
Count down to Words / Text | Excel Discussion (Misc queries) | |||
Count words in spreadsheets | Excel Discussion (Misc queries) | |||
Identify and count words | Excel Discussion (Misc queries) | |||
match and count words | Excel Worksheet Functions |