Table of Contents
In the previous article, you learned about the For loop, however, there is another loop called For...Each loop similar to For loop.
The For...Each loop is suitable to go through each item of a collection or an array.
Syntax: For…Each Loop
The syntax for the For..Each loop is given below.
For Each element In group
[Statements]
[Exit For] [Statements]
Next [element]The keywords are very much similar to for loop but with a difference that the For...Each loop is suitable for array.
Example Program: For…Each Loop
Private Sub Command1_Click()
Dim NumArray(2) As String
NumArray(0) = "Ram"
NumArray(1) = "Jaya"
NumArray(2) = "Bruce"
For Each ArrayItem In Num Array
MsgBox (ArrayItem)
Next ArrayItem
End SubThe above program goes through each item of the array and display the result.
Output – For…Each Loop
In the program above, each time you click on the “OK” button, a different name from the array is displayed.
