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.

Parameters 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

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

Copyright Help/Systems LLC and its group of companies.
All trademarks and registered trademarks are the property of their respective owners.

Parameters	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.