Returns a Variant (String) containing a repeating character string of the length specified.
The String function syntax has these named arguments:
|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.|
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.
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".
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.