Excel VBA: IF THEN Statement
VBA Excel: IF THEN Statement
This conditional statement enables you to check one condition and on the basis of that then run one or multiple statements if the condition holds. If the IF…THEN statement closes in the same line, the END IF is not required else IF…THEN statement should close with END IF.
Syntax
If <Condition> Then <Statement>
OR
If <Condition> Then
Example 1: The below program checks if in ‘Sheet1’, we have UK mentioned or not in the cell A2 and if UK is present, it will return London
Sub IF_Condition_Example1() 'checking the condition If Worksheets("Sheet1").Cells(2, 1).Value = "India" Then 'will return Delhi in cell B2 Worksheets("Sheet1").Cells(2, 2).Value = "Delhi" End If End Sub
Output
Example 2: If the cell (C2) is greater than 4 lakh, then divide the value by 100 and return the value in B2 by using IF, THEN.
Sub IF_Condition_Example2() 'Check if cell(C2) is greater than 400000 If Range("A2") > 400000 Then 'will return 8000 in cell B2 Range("B2") = Range("A2") / 100 End If End Sub
Output