StrConv Function
This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010.
Returns a Variant (String) converted as specified.
Syntax
StrConv(string, conversion, LCID)
The StrConv function syntax has these named arguments:
Part |
Description |
|---|---|
string |
Required. String expression to be converted. |
conversion |
Required. Integer. The sum of values specifying the type of conversion to perform. |
LCID |
Optional. The LocaleID, if different than the system LocaleID. (The system LocaleID is the default.) |
Settings
The conversion argument settings are:
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. |
vbNarrow* |
8* |
Converts wide (double-byte) characters in string to narrow (single-byte) characters. |
vbKatakana** |
16** |
Converts Hiragana characters in string to Katakana characters. |
vbHiragana** |
32** |
Converts Katakana characters in string to Hiragana characters. |
vbUnicode |
64 |
Converts the string to Unicode 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.) |
*Applies to East Asia locales.
**Applies to Japan only.
Note
These constants are specified by Visual Basic for Applications. As a result, they may be used anywhere in your code in place of the actual values. Most can be combined, for example, vbUpperCase + vbWide, except when they are mutually exclusive, for example, vbUnicode + vbFromUnicode. The constants vbWide, vbNarrow, vbKatakana, and vbHiragana cause run-time errors when used in locales where they do not apply.
The following are valid word separators for proper casing: Null (Chr$(0)), horizontal tab (Chr$(9)), linefeed (Chr$(10)), vertical tab (Chr$(11)), form feed (Chr$(12)), carriage return (Chr$(13)), space (SBCS) (Chr$(32)). The actual value for a space varies by country/region for DBCS.
Remarks
When converting from a Byte array in ANSI format to a string, use the StrConv function. When converting from such an array in Unicode format, use an assignment statement.
Example
This example uses the StrConv function to convert a Unicode string to an ANSI string.
Dim i As Long
Dim x() As Byte
x = StrConv("ABCDEFG", vbFromUnicode) ' Convert string.
For i = 0 To UBound(x)
Debug.Print x(i)
Next