IF THEN ELSE STATEMENT TUTORIAL IN VBA EXCEL 2007
IF is one of the most popular and frequently used statement in VBA. IF statement in VBA is sometimes also called as IF THEN ELSEStatement. The task of IF Statement is to check if a particular condition is met or not.
Excel IF function checks a particular condition and if the condition is TRUE, it returns one value otherwise it returns the second value.
On the other hand, VBA IF Statement checks a condition but it doesn’t return any value. If the condition evaluates to TRUE then, it simply takes the program control to the instructions inside the IF block and starts executing them sequentially. However, if the condition evaluates to FALSE then it takes the program control to the statements inside the Else Block.
Angelica Rioflorido
BSCS211