Tuto VBA

Boucles VBA

Les boucles VBA automatisent des tâches répétitives. Types clés : For...Next (nombre fixé d’itérations), Do While...Loop (condition vraie), Do Until...Loop (arrêt sur condition atteinte), et For Each...Next (traverser objets/collections). Puissant pour Excel et macros VBA.

Boucle While

Dim test As Integer
test = 0

Do While test < 5
	MsgBox test
	test = test + 1
Loop

Boucle Until

Dim test As Integer
test = 0

Do Until test = 5
	MsgBox test
	test = test + 1
Loop

Boucle For

''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''Lancer la boucle
Dim test As Integer

For test = 1 To 5
	MsgBox test
Next

''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''Quiter la boucle
Dim test As Integer

For test = 1 To 5
	MsgBox test
	If test = 2 Then
		Exit For
	End If
Next

Boucle For Each

Dim cellule As Range
    
For Each cellule In Range("A1:B3")
	MsgBox cellule.Address
Next