Control Structures

VBA provides conditional control functionality, which can be used to conditionally perform VBA statements or blocks of statements dependant upon the result of the condition tested. This is known as logical decision making.

The logical decision-making control structures available in VBA consist of three conditional looping or repetitive statements (Do Statement, While Statement, and For Statement), and two conditional flow control sequence statements (Select Case Statement, and variations of the If Statement). In addition, VBA provides one unconditional branching GoTo Statement.

Note: In the control structure syntax examples, every placeholder shown inside arrow brackets ( <placeholder> ) should be replaced in any actual code with the value of the item that it describes. The arrow brackets and the word they contain should not be included in the statement, and are shown here only for your information. Also, statements shown between square brackets ( [ ]) are optional. The square brackets should not be included in the statement, and are shown here only for your information.

See Also

Operators

GoTo Statement

Do Statement

While Statement

For Statement

If Statement

Select Case Statement

End Statement

Exit Statement

OnError Statement

Stop Statement

With Statement

VBA Function Reference