StrConv constants
The following constants can be used anywhere in your code in place of the actual values.
| Constant | Value | Description |
|---|---|---|
| vbUpperCase | 1 | Converts the string to uppercase characters. |
| vbLowerCase | 2 | Converts the string to lowercase characters. |
| vbProperCase | 3 | Converts the first letter of every word in string to uppercase. |
| vbWide | 4 | Converts narrow (single-byte) characters in string to wide (double-byte) characters. Applies to East Asia locales. |
| vbNarrow | 8 | Converts wide (double-byte) characters in string to narrow (single-byte) characters. Applies to East Asia locales. |
| vbKatakana | 16 | Converts Hiragana characters in string to Katakana characters. Applies to Japan only. |
| vbHiragana | 32 | Converts Katakana characters in string to Hiragana characters. Applies to Japan only. |
| vbUnicode | 64 | Converts the string to Unicode by using the default code page of the system (not available on the Macintosh). |
| vbFromUnicode | 128 | Converts the string from Unicode to the default code page of the system (not available on the Macintosh). |
See also
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for