VBA基础三:循环(DO...LOOP,)

Sub 基本示例()
Dim a%
a = -20
Do
a = a + 1
If a > 10 Then
MsgBox a & "终于大于10"
Exit Do
End If
Loop
End Sub

Sub 基本示例()
Dim rs%
rs = 1
Do
rs = rs + 1
If rs > 10 Then
Exit Sub
Else
If Cells(rs, 2) >= 90 Then Cells(rs, 3) = "√"
End If
Loop
End Sub

原文地址:https://www.cnblogs.com/yuanscn/p/13288435.html