VBA Loops to Python

Quick Reference: All VBA Loop Types

For / Next → for ... in range()

For i = 1 To 10
    total = total + i
Next i

for i in range(1, 10 + 1):
    total = total + i

For / Next with Step

' Count by 2
For i = 0 To 20 Step 2
    Debug.Print i
Next i

' Count down
For j = 10 To 1 Step -1
    Debug.Print j
Next j

# Count by 2
for i in range(0, 20 + 1, 2):
    print(i)

# Count down
for j in range(10, 1 - 1, -1):
    print(j)

Python's range(start, stop, step) maps directly to VBA's For i = start To stop Step step. The converter adjusts the stop value for both positive and negative steps.

For Each → for ... in

For Each cell In Range("A1:A20")
    If cell.Value > 100 Then
        cell.Interior.Color = RGB(255, 0, 0)
    End If
Next cell

for cell in ws["A1:A20"]:
    if cell.value > 100:
        cell.fill = PatternFill(
            start_color="FF0000",
            fill_type="solid"
        )

VBA For Each iterates over collections. Python for ... in works with any iterable. When iterating over cell ranges, openpyxl returns tuples of rows.

For Loop with Index → enumerate()

VBA For loops often use i as both a counter and an array index. Python's enumerate() is the direct equivalent — no separate counter needed.

Dim fruits(2) As String
fruits(0) = "Apple"
fruits(1) = "Banana"
fruits(2) = "Cherry"
For i = 0 To UBound(fruits)
    Debug.Print i & ": " & fruits(i)
Next i

fruits = ["Apple", "Banana", "Cherry"]
for i, fruit in enumerate(fruits):
    print(f"{i}: {fruit}")

Use enumerate(fruits, start=1) if your VBA array starts at 1 instead of 0.

Do While → while

row = 2
Do While Cells(row, 1).Value <> ""
    total = total + Cells(row, 1).Value
    row = row + 1
Loop

row = 2
while ws.cell(row=row, column=1).value != "":
    total = total + ws.cell(row=row, column=1).value
    row = row + 1

Do Until → while not

Do Until found = True
    row = row + 1
    If Cells(row, 1).Value = target Then
        found = True
    End If
Loop

while not (found == True):
    row = row + 1
    if ws.cell(row=row, column=1).value == target:
        found = True

Do Until condition becomes while not (condition). The converter wraps the negated condition in parentheses to preserve operator precedence.

Post-Condition Loops (Do ... Loop While/Until)

Do
    answer = InputBox("Enter value:")
Loop While answer = ""

while True:
    answer = input("Enter value:")
    if not (answer == ""):
        break

Python has no built-in do-while construct. The converter uses while Truewith a conditional break at the end to guarantee the body executes at least once.

Exit For / Exit Do → break

For i = 1 To 1000
    If Cells(i, 1).Value = "STOP" Then
        Exit For
    End If
Next i

for i in range(1, 1000 + 1):
    if ws.cell(row=i, column=1).value == "STOP":
        break

Both Exit For and Exit Do map to Python's break. Exit Sub and Exit Function map to return.

Common Pattern: Cell Processing Loop

The most common VBA loop pattern is iterating through rows, reading cells, processing data, and writing results. Here is a complete example with actual converter output.

Sub CleanNames()
    Dim i As Long
    Dim raw As String
    For i = 2 To 50
        raw = Cells(i, 1).Value
        If raw <> "" Then
            Cells(i, 2).Value = Trim(UCase(raw))
        End If
    Next i
End Sub

import openpyxl

def vba_trim(s):
    return str(s).strip()

def vba_ucase(s):
    return str(s).upper()

def CleanNames(ws):
    # Dim i As Long
    # Dim raw As String
    for i in range(2, 50 + 1):
        raw = ws.cell(row=i, column=1).value
        if raw != "":
            ws.cell(row=i, column=2).value = \
                vba_trim(vba_ucase(raw))

This example combines loops, cell access, conditionals, and string functions — all handled automatically by the converter.

Related Guides

• Complete Syntax Mapping Reference — All control flow patterns in one page.
• Excel VBA to Python with openpyxl — Range and Cells patterns used inside loops.
• VBA Arrays & ReDim to Python — Building arrays inside loops.