Excel-宏与VBA-循环结构

学习视频，本文是观看前视频时做的笔记，手动感谢up??。

for

1. 基本使用案例
   Next num，让num自增1
   To 5，当>5时，停止循环

Sub ForNextTest()
  Dim num As Integer
  For num = 1 To 5
    MsgBox num
    Next num
End Sub

2. step
   step控制每一步Next自增多少

Sub ForNextTest()
  Dim num As Integer
  For num = 1 To 5 Step 2
    MsgBox num
    Next num
End Sub

3. Exit For
   Exit For，用来退出For循环

Sub ForNextTest()
  Dim num As Integer
  For num = 1 To 5
    If num > 50 Then
      Exit For
    MsgBox num
    Next num
End Sub

Do While

满足条件就继续循环

1. 基本使用案例

Sub ForNextTest()
  Dim num As Integer = 1
  Do While num <= 10
    num = num + 1
    MsgBox num
  Loop
End Sub

Do Until

不满足条件就继续循环

1. 基本使用案例

Sub ForNextTest()
  Dim num As Integer = 1
  Do Until num > 10
    num = num + 1
    MsgBox num
  Loop
End Sub