VBA - Decisions
Decision making allows the programmers to control the execution flow of a script or one of its sections. The execution is governed by one or more conditional statements.
Following is the general form of a typical decision making structure found in most of the programming languages.
VBA provides the following types of decision making statements. Click the following links to check their details.
|Sr.No.||Statement & Description|
An if statement consists of a Boolean expression followed by one or more statements.
An if else statement consists of a Boolean expression followed by one or more statements. If the condition is True, the statements under If statements are executed. If the condition is false, the Else part of the script is executed.
An if statement followed by one or more ElseIf statements, that consists of Boolean expressions and then followed by an optional else statement, which executes when all the condition become false.
nested if statements
An if or elseif statement inside another if or elseif statement(s).
A switch statement allows a variable to be tested for equality against a list of values.