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 |
|---|---|
| 1 | if statement An if statement consists of a Boolean expression followed by one or more statements. |
| 2 | if..else statement 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. |
| 3 | if…elseif..else statement 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. |
| 4 | nested if statements An if or elseif statement inside another if or elseif statement(s). |
| 5 | switch statement A switch statement allows a variable to be tested for equality against a list of values. |
Pingback: VBA - If Statement - Adglob Infosystem Pvt Ltd
Pingback: VBA - If-Else Statement - Adglob Infosystem Pvt Ltd