VBA 中的“To”和“Step”是什么意思

VBA（Visual Basic for Applications）是一种用于Microsoft Office应用程序的编程语言。在VBA中，我们经常会遇到"To"和"Step"这两个关键词。它们在循环语句中起到了重要的作用，用于控制循环的范围和步长。

Dim total As Integer
total = 0
For i = 1 To 10
    total = total + i
Next i
MsgBox "总和为：" & total

Dim total As Integer
total = 0
For i = 1 To 10 Step 2
    total = total + i
Next i
MsgBox "偶数的总和为：" & total

Dim sum As Integer
Dim count As Integer
Dim average As Double
sum = 0
count = 0
For i = 1 To 100 Step 2
    sum = sum + i
    count = count + 1
Next i
average = sum / count
MsgBox "奇数的平均值为：" & average