Skip to main content

String function

Table of contents
  1. Syntax
  2. Remarks
  3. Example

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

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>