XL2000: Sample Macro Code to Change Case of Text (213649)
The information in this article applies to:
This article was previously published under Q213649 For a Microsoft Excel 2002 version of this article, see 291323.
For a Microsoft Excel 98 and earlier version of this article, see 141094.
SUMMARY
Although Microsoft Excel has functions that change the case of text, there are times when you may want to change text case programmatically.
This article contains three sample Microsoft Visual Basic for Applications
macros (Sub procedures) that you can use to change the letters in a text string to all uppercase, all lowercase, or title case (the first letter in each word is capitalized).
These actions are similar to the Excel functions, =UPPER(), =LOWER(), and =PROPER().
REFERENCES
For additional information about getting help with Visual Basic for
Applications, please see the following article in the Microsoft Knowledge
Base:
226118
OFF2000: Programming Resources for Visual Basic for Applications
Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
---|
Keywords: | kbdtacode kbhowto kbProgramming KB213649 |
---|
|