Step 8: Run the above code from the run button in VBA or we can press the F5 button to do the same. Step 7: Let us compare both the variables using IF NOT statement by the following code, Step 6: Now we will assign these variables the values of A1 and B1.

Step 5: To assign values to these variables we need to activate the worksheet first by the following code. Step 4: Declare two variables as integers which will store our values from cell A1 and B1. Step 3: Every VBA code starts with a sub-function as below, Double click on the module we just inserted to open another window where we are going to write our code. Step 2: Insert a module from the insert tab in the VB Editor. Step 1: Go to the developer’s tab and then click on Visual Basic to open the VB Editor. What I want to do is compare these two values which one is greater using IF NOT statement in VBA. You can download this VBA IF NOT Excel Template here – VBA IF NOT Excel Template Example #1 – VBA IF Notįollow the below steps to use IF NOT in Excel VBA.įor example, I have two values in sheet 1 in cell A1 and B1.

Visual basic for excel not showing