VBA - 用字符串初始化数组的正确方法

使用VBA编程语言时，有时候我们需要初始化一个数组并将其填充满字符串值。在这种情况下，我们可以使用一种特定的方法来正确地初始化数组，并确保每个元素都包含所需的字符串。

Dim myArray(1 To 5) As String

Dim myArray(1 To 5) As String
Dim i As Integer
For i = 1 To 5
    myArray(i) = "Value " & i
Next i

vba
Sub InitializeArray()
    Dim myArray(1 To 5) As String
    Dim i As Integer
    
    For i = 1 To 5
        myArray(i) = "Value " & i
    Next i
    
    ' 打印数组的元素值
    For i = 1 To 5
        Debug.Print myArray(i)
    Next i
End Sub

Value 1
Value 2
Value 3
Value 4
Value 5