Collapse the table of content
Expand the table of content
Expand Minimize

String Function

Office 2010
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.


String(number, character)

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.

Dim MyString
MyString = String(5, "*")    ' Returns "*****".
MyString = String(5, 42)    ' Returns "*****".
MyString = String(10, "ABC")    ' Returns "AAAAAAAAAA".

© 2015 Microsoft