This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010.
Returns a Variant (String) containing a repeating character string of the length specified.
The String function syntax has these named arguments:
Required; Long. Length of the returned string. If number contains Null, Null is returned.
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 using the formula:
character Mod 256
This example uses the String function to return repeating character strings of the length specified.
MyString = String(5, "*") ' Returns "*****".
MyString = String(5, 42) ' Returns "*****".
MyString = String(10, "ABC") ' Returns "AAAAAAAAAA".