Returns a Variant (String) containing a repeating character string of the length specified.
Syntax
String(number, character)
The String function syntax has these named arguments:
| Part | Description |
|---|---|
| number | Required; Long. Length of the returned string. If number contains Null, Null is returned. |
| character | Required; Variant. Character code specifying the character or string expression whose first character is used to build the return string. If character contains Null, Null is returned. |
Remarks
If you specify a number for character greater than 255, String converts the number to a valid character code by using this formula: character Mod 256.
Example
This example uses the String function to return repeating character strings of the length specified.
Dim MyString
MyString = String(5, "*") ' Returns "*****".
MyString = String(5, 42) ' Returns "*****".
MyString = String(10, "ABC") ' Returns "AAAAAAAAAA".