The For Each...Next statement executes a group of statements on each member of an array or collection

 
Private Sub cmdForEachNext_Click()
    Dim ctl As Control
    For Each ctl In Controls
        ctl.FontSize = 8
    Next ctl
End Sub

1.	Intrinsic Constant Type of Control
2.	Determining the Type of a Control
3.	Manipulating a Single Control
4.	With...End With construct is often used along with the For Each...Next construct
5.	The With...End With statement executes a series of statements on a single object or user-defined type
6.	Change fonts of controls on a form
7.	change control back ground color
8.	Control Types
9.	Controls and Errors

The For Each...Next statement executes a group of statements on each member of an array or collection : Form Control « Forms « VBA / Excel / Access / Word