Visual Basic for Applications Reference

String Function

See Also Example Specifics

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


String(number, character)

The String function syntax has these named arguments:

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

characterMod 256