The IF function sometime also called as IF THEN ELSE Statement in VBA is one of the most popular used of all statements. The IF function checks if the specified condition is being met or not.
It check if the condition evaluates to TRUE or FALSE.
So Here is a simple program to understand the if else concepts in VBA
dim x as Integer
If x > 50 Then
MsgBox “Value is greater than 50”
MsgBox “Value is less than 50”
So here you have declared a variable called X, contain numeric value 30.
You have a condition if the value of X is greater than 50 then it should say “Value is greater than 50” otherwise it should say “Value is less than 50”. As we can see the current value is less than 50 and the output will be “Value is less than 50”.
Note: Although, it is not mandatory to have an Else Block with every IF statement. In such a case, if the condition inside IF statement evaluates to FALSE then the program control just moves to the next instruction (the instruction after the IF Block) and starts executing them sequentially.
Example: to check whether the cell number is greater than five thousand
If Range(“B2”) > 5000 Then
Range(“C2”) = Range(“B2”) * 5 / 100
Range(“C2”) = Range(“B2”) * 10 / 100
Example: To check a number is Even or Odd
dim num as Integer
num =InputBox(“Enter a Number”)
if num MOD 2 = 0 then
MsgBox “Number is Even”
MsgBox “Number is Odd”