Excel VBA: "For" and "If" statement on a single line?

Question

Is it somehow possible in VBA to put a For and If statement in a single line? The closest what I could get is this:

For i = 0 To n: If a = i Then a = b
Next i

If I write:

For i = 0 To n: If a = i Then a = b: Next i

I get the "Next without For" error.

Answer 1

You can do it with IIf, rather than If.

This code won't throw the error:

For i = 0 To n: IIf a = i, a = b, False: Next i