Step 7: Now assign some values to each defined variable as per their character of data types. Step 6: Declare the 2 more variables as Double and Long where we will try to store decimal value and large values in 6 digits.ĭim A As Integer Dim B As Double Dim C As Long End Sub In a similar way, let’s define different types of variables in the same code and see, what changes happen. We will see, the value stored in variable A is now printed in the Immediate window. Step 5: Now we will run the code by pressing F5 key. Step 4: Now we will use Debug print and assign the variable which we have just defined directly. Step 3: Assign any value to that integer. Step 2: We will need a variable as an Integer. Step 1: In a module, write the subcategory in any name as shown below. In this example, we will see, how to print any value using Debug print in excel VBA. We will see, the Debug print has omitted the output in Immediate window as shown below. Step 6: Now compile the code and run it by clicking on the Play button located below the menu bar. This is a place where we will be seeing all the output from Debug Print.

So, we will be opening the Immediate Window from the View menu bar as shown below.Īfter that, we will be getting a blank Immediate Window as shown below. Step 5: As we know, the output of Debug Print will only be seen in Immediate Window. Step 4: Let’s print any random text which we want to see and quote that text in inverted commas to see the output.ĭebug.Print 'This is how Debug Print works!!' As we discussed, Debug Print doesn’t have any syntax. Step 3: Now directly use Debug Print as shown below.

Step 2: In the newly opened Module, write the subcategory VBA Debug Print or you can choose any other name for that.

How to debug vba in excel 2016