In this scenario, IF & ELSE statement is used to execute two different conditions. The format or syntax to write code is: The VBA message box popup window appears with message stating “3 is greater than 2” You can run the macro by clicking the Run Sub button or by pressing F5. “3 is greater than 2”. If you change the value from “ 2” to “ 5” in the VBA code and run it, then nothing happens. If the value “3” is greater than “2″, then popup message appears with message i.e. Let’s check out with the above code which has a single line of IF statement that verifies or checks the value 3. Now, all the codes which you enter must be between these two lines. When you type Sub IF_THEN() as the first message without any quotes around it, you can observe, Excel automatically adds the line End Sub below the first message line when you press Enter. You should use matching End If statement after entering the above syntax, When the condition meets or criteria evaluates to true, then all the lines between If Then and End If are processed. IF THEN is a simple form of VBA statement. The format to write a code is: Now the blank module is created, it is also called a code window, where you can start writing if statement codes.Now go to the Insert menu from VBA window and select Module as shown below. This will take us to Visual Basic coding window.Select or click on Visual Basic in the Code group on the Developer tab or you can directly click on Alt + F11 shortcut key. You can download this VBA IF Statements Excel Template here – VBA IF Statements Excel Template
0 kommentar(er)
