Excel visual basic code#

Here, based on the value present in the cell, different result occurs (i.e. If the cell B4 contains a value 7, then you will get a message box showing вЂњCell B4 has value 7вЂќ and If the cell B4 contains a value other than 7, then you will get a message box showing вЂњCell B4 has a value other than 7вЂќ.

Excel visual basic code#

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