Skip to main content

Procedure

With...End With

The With...End With construct cannot be called a control statement because it does not modify code execution. It does, however, provide a handy shorthand that simplifies writing code in certain situations.

If...Then Statement

The If...Then statement, or If statement for short, is used in a program to execute a block of code if a specified logical condition is True.  If condition is True, the statements in the block (indicated by block1) are executed. If condition is False, they are not executed.

For...Next Statement

The For...Next statement repeats a block of code a specified number of times.

  • Index is a variable that is used to count loop repetitions. It is usually declared to be type Integer.
  • Start is an expression specifying the starting value of index.
  • Stop is an expression specifying the ending value of index.

Optionally, For...Next can use an increment value other than 1.