by Allen Wyatt
(last updated June 26, 2018)
When you are developing macros, it is often helpful to know how many characters are in a text selection. The following VBA macro, CharCount, will display the number of characters in a selection.
Sub CharCount() Dim Title As String Dim CharCount As Integer Dim Message As String Title = "CharCount" CharCount = Len(Selection) Message = LTrim(Str(CharCount)) + " character" If CharCount <> 1 Then Message = Message + "s" MsgBox Message, vbOKOnly, Title End Sub
WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (746) applies to Microsoft Word 97, 2000, 2002, and 2003.
The First and Last Word on Word! Bestselling For Dummies author Dan Gookin puts his usual fun and friendly candor back to work to show you how to navigate Word 2013. Spend more time working and less time trying to figure it all out! Check out Word 2013 For Dummies today!
How to construct a word frequency list.Discover More
Word makes it easy to insert today's date in a document, but not as easy to insert a date X number of days in the future. ...Discover More
When creating a macro, you may need to figure out how many fonts are available to Word. You can do this using the ...Discover More
FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
Got a version of Word that uses the menu interface (Word 97, Word 2000, Word 2002, or Word 2003)? This site is for you! If you use a later version of Word, visit our WordTips site focusing on the ribbon interface.