Please Note: This article is written for users of the following Microsoft Word versions: 2007, 2010, 2013, and 2016. If you are using an earlier version (Word 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Word, click here: Underlining Quoted Text.
by Allen Wyatt
(last updated December 5, 2015)
For some documents, you may have the need to underline information within quotes. For instance, for some legal documents you may need to find all material surrounded by quotes, and then make the information between the quotes underlined. This is different from regular prose writing, where you would use either underlines or quotes, but not both.
If you have a need to search for all quoted text and make it underlined, you can use the following macro. It searches for quote marks and when it finds one, it underlines everything up to the next quote mark. Note that it will not actually underline the quote marks themselves.
Sub UnderlineQuoted() Dim bDelQuotes As Boolean Dim bMvRt As Boolean Selection.HomeKey Unit:=wdStory ' controls deletion of quote marks bDelQuotes = False With Selection.Find .ClearFormatting .Text = Chr(34) .Replacement.Text = "" .Forward = True .Wrap = wdFindStop .Execute End With While Selection.Find.Found Selection.MoveRight Unit:=wdCharacter, Count:=1 ' switch on selection extend mode Selection.ExtendMode = True bMvRt = True ' find second quote of this pair Selection.Find.Execute If Selection.Find.Found Then Selection.MoveLeft Unit:=wdCharacter, Count:=1 If Len(Selection.Range.Text) > 0 Then ' make it underlined Selection.Font.Underline = True ' delete quote marks, if appropriate If bDelQuotes Then Selection.Cut Selection.TypeBackspace Selection.Delete Unit:=wdCharacter, Count:=1 Selection.Paste bMvRt = False End If End If End If Selection.ExtendMode = False If bMvRt Then Selection.Collapse Direction:=wdCollapseEnd Selection.MoveRight Unit:=wdCharacter, Count:=1 End If Selection.Find.Execute Wend End Sub
Pay attention to the setting of the bDelQuotes variable. If set to False (as it is here), then the quote marks themselves are not deleted by the macro. If you change the value of the variable to True, then the macro gets rid of the quote marks in the document. Note that it only gets rid of the quote marks if it actually underlines text between those quote marks.
WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (10473) applies to Microsoft Word 2007, 2010, 2013, and 2016. You can find a version of this tip for the older menu interface of Word here: Underlining Quoted Text.
Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!
If your documents don't behave as you expect, it may take a bit of sleuthing to figure out what is going on. This tip ...Discover More
Want to get your typeface exactly the right size? Here's how you can specify just the size you want Word to use.Discover More
Word gives you control over how your text appears on the page. This includes adjusting how close letters are to each ...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 ribbon interface (Word 2007 or later)? This site is for you! If you use an earlier version of Word, visit our WordTips site focusing on the menu interface.