Excel VBA String Function

The String function in VBA creates a String, consisting of several repeated characters.

Syntax

String (Number, Character)

Parameter

Number (required) – This parameter represents the number of characters in the returned String.

Character (required) – This parameter signifies a character code or a String, representing the character that is to be repeated in the returned String.

Return

This parameter returns a String consisting of several characters. If the Number or Character arguments are Null, the String function returns Null.

Example 1

Sub StringFunction_Example1()
 Dim str1 As String
 Dim str2 As String
 Dim str3 As String
 str1 = String(10, 97)
 Cells(1, 1) = str1
 str2 = String(10, "a") 
 Cells(1, 2) = str2
 str3 = String(10, "about")
 Cells(1, 3) = str3
 ' All the three variables will return "aaaaaaaaaa".
 End Sub 

Output

aaaaaaaaaa

aaaaaaaaaa

aaaaaaaaaa