For Next
语法:For counter = start To end [ Step step ] … next
--中途退出:exit for
-- step缺省值为1
实例:
For cnt = 1 to 9 step 1 Debug.print cnt If cnt = 8 then : exit for next
For Each … Next
语法
For Each element In group Statements [Exit for] Statements Next [element]
Do {while |until} condition … loop
-- while 当满足条件时循环
-- until 当满足条件时停止循环
语法1:
Do {while |until} condition Statements [Exit do] Statements Loop
--先检测是否满足循环条件,满足循环条件则执行代码块
语法2:
Do Statements [Exit do] Statements Loop {while |until} condition
--不管满不满足循环条件,先执行一遍代码块,再检测是否满足循环条件,满足循环条件则继续执行代码块
While … wend
满足条件时循环,VB老语法,不推荐用
其他循环语句:不重要
联系客服