For Statement

Syntax:

For Num = First To Last [Step Inc]

  statements

Next [Num]

Group:Flow Control

Description:
Execute statements while Num is in the range First to Last.

Parameter Description

Num This is the iteration variable.

First Set Num to this value initially.

Last Continue looping while Num is in the range. See Step below.

Step If this numeric value is greater than zero then the for loop continues as long as Num is less than or equal to Last. If this numeric value is less than zero then the for loop continues as long as Num is greater than or equal to Last. If this is omitted then one is used.

See Also:Do, For Each, Exit For, While.

Example:

Sub Main
  For I = 1 To 2000 Step 100
  Debug.Print I;I+I;I*I
  Next I
EndSub