String Function

μ§€μ •ν•œ 문자 λ˜λŠ” ν•¨μˆ˜μ— μ „λ‹¬λ˜λŠ” λ¬Έμžμ—΄ μ‹μ˜ 첫 번째 λ¬Έμžμ— 따라 λ¬Έμžμ—΄μ„ λ§Œλ“­λ‹ˆλ‹€.

Syntax:


String (number As Long, {expression As Integer | character As String}) As String

Return value:

String

Parameters:

number: Numeric expression that indicates the number of characters to return in the string. The maximum allowed value of n is 2,147,483,648.

Expression: Numeric expression that defines the ASCII code for the character.

Character: Any single character used to build the return string, or any string of which only the first character will be used.

Error codes:

5 잘λͺ»λœ ν”„λ‘œμ‹œμ € ν˜ΈμΆœμž…λ‹ˆλ‹€.

Example:


Sub ExampleString
Dim sText As String
    sText = String(10,"A")
    MsgBox sText
    sText = String(10,65)
    MsgBox sText
End Sub