VBA 中的列表和数组

VBA中的列表和数组在编程中起着重要的作用。列表是一种存储和组织数据的方式，可以按照一定的顺序访问其中的元素。而数组则是一种特殊的列表，它可以存储多个相同类型的数据，并通过索引来访问和操作这些数据。

vba
Dim myArray(10) As Integer

vba
myArray(0) = 100

vba
For i = 0 To 10
    myArray(i) = myArray(i) + 10
Next i

vba
Dim scores(4) As Double
scores(0) = 85.5
scores(1) = 90.0
scores(2) = 78.5
scores(3) = 92.0
scores(4) = 88.5
Dim total As Double
total = 0
For i = 0 To 4
    total = total + scores(i)
Next i
Dim average As Double
average = total / 5
MsgBox "平均分为：" & average