Name
For . . . Next Statement
Syntax
Forcounter
=initial_value
Tomaximum_value
[Stepstepcounter]
code to execute on each iteration
[Exit For] Next
counter
Use: Required
Data Type: Numeric
A variable to be used as the loop counter.
initial_value
Use: Required
Data Type: Numeric
Any valid numeric expression that specifies the loop counter’s initial value.
maximum_value
Use: Required
Data Type: Numeric
Any valid numeric expression that specifies the loop counter’s maximum value.
stepcounter
Use: Optional (required if
Step
used)Data Type: Numeric
Any valid numeric expression that indicates how much the loop counter should be incremented with each new iteration of the loop.
Description
Defines a loop that executes a given number of times, as
determined by a loop counter. To use the For...Next
loop, you must assign a numeric
value to a counter variable. This counter is either incremented or
decremented automatically with each iteration of the loop. In the
For
statement, you specify the
value that is to be assigned to the counter initially and the
maximum value the counter will reach for the block of code to be
executed. The Next
statement
marks the end of the block of code that is to execute repeatedly,
and also serves as a kind of flag that indicates the counter
variable is to be modified.
Rules at a Glance
If
initial_value
is greater thanmaximum_value
, and noStep
keyword is used or the step counter is positive, theFor...Next
loop is ignored and execution commences with the first line of code immediately ...
Get VBScript in a Nutshell, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.