Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

String Function

Returns a repeating character string of the length specified.

                      String(number, character)


Length of the returned string. If number contains Null, Null is returned.


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 using the formula:

character Mod 256

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

Community Additions

© 2015 Microsoft