Conditional statements and Loop structure

The If…Then statement is used to evaluate whether a condition is True or False. You can use If…Then block to execute one or more statements conditionally. Syntax: If <condition> Then [statements] Else [else statements] End …

It conditionally executes a group of statements depending upon value of the expression. If…Then…Else block is used to define several blocks of statements ,in order to execute one block. Syntax: If <condition>then [statements] Else if …

It is just as the alternative of If…Then…Else statement.It executes one statement in several groups of statements. A Select Case provides the same functionality as the If…then…Else statement but it makes the code more efficient …

Do…loop is used to execute a block of statements for indefinite number of times. There are several variations of Do…Loop statement. Each variation evaluates a numeric condition to determine whether to continue execution or not. …

For…Next loop is used when you know how many times you want to execute loop.But in case of Do While it is not the case. Do While is used when you do not know how …