#Excel vba debug print how to
#Excel vba debug print code

PrintLine can be used to print rows of data with defined length (i.e. Public Sub PrintHeader2(ParamArray args() As Variant)ĭebug.Print Strings.String(C_LINE_LENGTH, '-') Public Sub PrintHeader1(ParamArray args() As Variant)ĭebug.Print Strings.String(C_LINE_LENGTH, '=')

#Excel vba debug print how to

Here we discuss how to use Print Function in Excel VBA along with some practical examples and downloadable excel template.Headers are simply PrintLine + border style, and C_LINE_LENGTH is simply a module integer constant (defined as 110): Print Header 1 ''' Always remember when you are typing Activesheet function as you can see in Step 2 of Example 2, then make sure that your cursor (click) before executing the command is upon the same sheet whose Print you require.VBA function can directly be accessed by Alt+F11 instead of going through Developer mode.We should always remember not to provide spaces in between the functions.We have learned in the first few steps on how to create Macros. The VBA function becomes accessible after creating Macros for the source data.I hope we now have a better understanding and implementation of the function. So, this is how the functions in VBA Print can be used for performing Printouts directly.

The Print Preview helps us in looking through the data before moving ahead with the Print. As soon as we execute the command, the following screen automatically appears.

#Excel vba debug print code

Step 3: Run this code by hitting F5 directly or manually hitting the Run button on the upper left panel. Step 2: In this, the function “Printpreview” is used. Step 1: In the VBE, start writing the macro and define the variable name. To explain the Print preview function in VBA, we have used the same data as used in the previous example as follows: This helps us in looking at the data, as to how it will appear at the time of Print, before moving ahead with the execution. In the same way, we have one more function related to Print called Print Preview in VBA. Step 10: We can directly execute by pressing F5 or clicking on the play button.Īs soon as we press the Execution command, the document area is automatically taken to the Printer for Printing. In case we do not enter the above-mentioned command, the following message displays while execution. Unless we enter this command, the arguments are considered incomplete. Step 10: To end the command we need to enter “End Sub”. But we can customize this option also, if necessary.Ī copies:=1, collate:= True, IgnorePrintAreas:= False End Sub Step 9: We have also mentioned “Ignore print areas” because we have only 1 sheet to print and that is well within the ambit of Print areas. In the above function,Ī copies:=1, collate:= True End Sub By inputting “ Collate _:=True” function we ensure that the data is composed together in the sheet. Step 8: The next argument is “ Collate” function. We can customize it based on a number of copies we need to print. But we can also modify the details like 2 or 3 copies if required. Step 8: After putting the “Printout” option, we select the number of copies in the argument.Ī copies:=1įor instance, in our example, we have mentioned “ Copies=1”. Step 7: Then we have to use “ Printout” option in VBA which appears on the screen. The command “Selected Sheets” denotes that the same data has been copied from the source sheet where data is mentioned. Step 6: The first command is the source data which we have mentioned as Macro1. Step 5: Now let us start writing the code, to do that we need to name the macro first as follows, The subject shall start with command “Sub- Print1 ()” since the information database is taken from Macro1 which we created in Step 2. Step 4: Once we are in VBA we need to insert a module so that we can write code in it. For getting the option on Excel, we need to follow the instruction as follows: Click on Developer’s tab then click on Visual Basic to get into VBA. The Print function can be used in VBA with the help of a Developer option. Once the Macro is created we can proceed with creating the Print option. In the present case, we have kept the name of our Macros as “ Macro1” which is a default name provided. Select the Data- View-Macros – Record Macro.Īs soon as we put this option, we get the below mentioned screen.

Follow the below steps to use the Print function in Excel VBA.