(10.5.1)--8.5For...NextStatements.ppt
《(10.5.1)--8.5For...NextStatements.ppt》由会员分享,可在线阅读,更多相关《(10.5.1)--8.5For...NextStatements.ppt(10页珍藏版)》请在得力文库 - 分享文档赚钱的网站上搜索。
1、For.Next Loop数据库技术与程序设计Loop StructureWhile programming,we often facing a situation where a While programming,we often facing a situation where a repeated execution is always needed.repeated execution is always needed.The Loop Structure can meet the demands.The Loop Structure can meet the demands.The
2、 Loop Structure The Loop Structure can control the repeated execution of a can control the repeated execution of a certain part of the statements sequence in the program by certain part of the statements sequence in the program by specifiying the current value of the given conditions.specifiying the
3、 current value of the given conditions.数据库技术与程序设计Loop Structure VBA provides four loop statements:,which are:Do While.LoopDo While.LoopFor.NextFor.NextWhile.WendWhile.WendDo Until.LoopDo Until.Loop数据库技术与程序设计ForNext StatementForNext Loop is also called numeric for-loops.SyntaxFor =To Step statements
4、Exit For statementsNext counterExecution:the VBA will first calculate the counters start,end and step as well as assign initial value to the counter.Then it compares the counter(assigned value already)with end.If the counter is less than end(only if step is positive or 0),or more than/equal to end(o
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 10.5 8.5 For NextStatements
限制150内