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

Syntax

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

Output

aaaaaaaaaa aaaaaaaaaa aaaaaaaaaa
VBA String Function

Pin It on Pinterest

Share This