For Loops with different steps : For « Language Basics « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Language Basics
  3. For

For Loops with different steps

 
Sub ForSteps()
    Dim I As Integer

    For I = 0 To 10
      MsgBox (I)
    Next I
    For I = 0 To 10 Step 2
      MsgBox (I)
    Next I
    For I = 0 To 10 Step 3
      MsgBox (I)
    Next I
    For I = 10 To 0 Step -5
      MsgBox (I)
    Next I

End Sub








Related examples in the same category

1.you can go backward and use increments other than 1
2.For...Next Loop
3.The For...Next construct is used when you have an exact number of iterations you want to perform
4.For loop whose step is 2
5.Checks values in a range 10 rows by 5 columns
6.Nest if statement into a for statement
7.Iterates six times outputting the numbers 0, 2, 4, 6, 8, and 10 in a message box:
8.iterates four times outputting the numbers 0, 3, 6, and 9 in a message box:
9.the loop iterates just three times outputting the numbers 10, 5, and 0 in a message box:
10.Non integer step for loop