String

Returns a String containing a repeating character string of the length specified.

Syntax: String$( number, character ), String( number, character )

number
required Long. Length of the returned string.
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, String returns Null; String$ raises error 94.

The $-suffixed form returns a String; the unsuffixed form returns a Variant (String).

When character is a number greater than 255, String converts the number to a valid character code by using this formula: character Mod 256.

Common Errors

Error When
5 (&H5), Invalid procedure call or argument number is negative, or greater than 1,073,741,823
character is a zero-length string
94 (&H5E), Invalid use of Null number is Null, or String$ is given a character that is Null

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".

See Also