VB & VBA in a Nutshell: The Language

StrConv Function

Named Arguments

Yes

Syntax

StrConv(string, conversion)

string

Use: Required

Data Type: String

The string expression to convert.

conversion

Use: Required

Data Type: Integer

Sum of constant or numeric values denoting the conversion to apply to string.

Return Value

A Variant of subtype String converted according to conversion.

Description

Performs special conversions on a string.

Rules at a Glance

• The following intrinsic conversion constants specify the type of conversion to perform:

  Constant	Value	Converts...
  vbUpperCase	1	the entire string to uppercase.
  vbLowerCase	2	the entire string to lowercase.
  vbProperCase	3	the first letter of every word in string to an uppercase character.
  vbWide	4	narrow (single-byte) characters in string to wide (double-byte) characters.
  vbNarrow	8	wide (double-byte) characters in string to narrow (single-byte) characters.
  vbKatakana	16	Hiragana characters in string to Katakana characters.
  vbHiragana	32	Katakana characters in string to Hiragana characters.
  vbUnicode	64	the entire string to Unicode using the default code page of the system.
  vbFromUnicode	128	the entire string from Unicode to the default code page of the system.

• You can combine most of these constants by adding them together or using a logical OR. For example:

  vbUpperCase + vbUnicode

  The only restriction is that the constants must be mutually exclusive. For example:

  vbUpperCase Or vbProperCase   ' Error

  is the type of value that's not permitted.

• vbKatakana and ...