Converting Text to Uppercase in a Macro

Summary: The VBA macro language includes the ability to modify the capitalization of a text selection. There are two ways to perform this conversion, as you discover in this tip. (This tip works with Microsoft Word 97, Word 2000, Word 2002, and Word 2003.)

There are two ways you can convert text to uppercase in Word. The first is to use the AllCaps property and the second is to use the Case property. The following shows how to use both methods.

Selection.Font.AllCaps = True
Selection.Range.Case = wdUpperCase

Both of these statements assume you have selected the text to be changed prior to issuing the statements. The difference between them is that the AllCaps property controls only the formatting of the text--it only appears as uppercase. The Case property, on the other hand, actually changes the letters in the selection so they are uppercase.

Tip #1723 applies to Microsoft Word versions: 97 | 2000 | 2002 | 2003

Create and Merge! Using Word's mail merge tool you can quickly and easily combine data from a variety of data sources to create great individualized documents that incorporate your data in ways that you control. WordTips: Mail Merge Magic is an invaluable source for learning how to harness the full power of Word's mail merging capabilities.

Check out WordTips: Mail Merge Magic today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Converting Text to Uppercase in a Macro