Excel-宏与VBA-循环结构
学习视频,本文是观看前视频时做的笔记,手动感谢up🐖。
for
- 基本使用案例
Next num
,让num自增1
To 5
,当>5时,停止循环
Sub ForNextTest()
Dim num As Integer
For num = 1 To 5
MsgBox num
Next num
End Sub
- step
step
控制每一步Next自增多少
Sub ForNextTest()
Dim num As Integer
For num = 1 To 5 Step 2
MsgBox num
Next num
End Sub
- 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
满足条件就继续循环
- 基本使用案例
Sub ForNextTest()
Dim num As Integer = 1
Do While num <= 10
num = num + 1
MsgBox num
Loop
End Sub
Do Until
不满足条件就继续循环
- 基本使用案例
Sub ForNextTest()
Dim num As Integer = 1
Do Until num > 10
num = num + 1
MsgBox num
Loop
End Sub
开心就完事了🥱
赠人玫瑰🌹手有余香
能帮到你我很高兴
您的赞👍是我前进的动力,奥力给
Thanks for watching!
赠人玫瑰🌹手有余香
能帮到你我很高兴
您的赞👍是我前进的动力,奥力给
Thanks for watching!