Table of contents
Collapse the table of content
Expand the table of content

Print Method

office 365 dev account|Last Updated: 6/12/2017
1 Contributor

Prints text in the Immediate window. Syntaxobject.Print [ outputlist ] The Print method syntax has the following object qualifier and part:

objectOptional. An object expression that evaluates to an object in the Applies To list.
outputlistOptional. Expression or list of expressions to print. If omitted, a blank line is printed.

The outputlistargument has the following syntax and parts: { Spc(n) |Tab(n) } expression charpos

Spc(n)Optional. Used to insert space characters in the output, where n is the number of space characters to insert.
Tab(n)Optional. Used to position the insertion point at an absolute column number where n is the column number. Use Tab with no argument to position the insertion point at the beginning of the nextprint zone.
expressionOptional. Numeric expression orstring expression to print.
charposOptional. Specifies the insertion point for the next character. Use a semicolon ( ; ) to position the insertion point immediately following the last character displayed. Use Tab(n) to position the insertion point at an absolute column number. Use Tab with no argument to position the insertion point at the beginning of the next print zone. If charpos is omitted, the next character is printed on the next line.

Remarks Multiple expressions can be separated with either a space or a semicolon. All data printed to the Immediate window is properly formatted using the decimal separator for thelocale settings specified for your system. Thekeywords are output in the appropriate language for thehost application. For Boolean data, either True or False is printed. The True and False keywords are translated according to the locale setting for the host application. Date data is written using the standard short date format recognized by your system. When either the date or the time component is missing or zero, only the data provided is written. Nothing is written if outputlist data isEmpty. However, if outputlist data isNull, Null is output. The Null keyword is appropriately translated when it is output. For error data, the output is written as Error errorcode. The Error keyword is appropriately translated when it is output. The object is required if the method is used outside amodule having a default display space. For example an error occurs if the method is called in astandard module without specifying an object, but if called in a form module, outputlist is displayed on the form.

Note Because the Print method typically prints with proportionally-spaced characters, there is no correlation between the number of characters printed and the number of fixed-width columns those characters occupy. For example, a wide letter, such as a "W", occupies more than one fixed-width column, and a narrow letter, such as an "i", occupies less. To allow for cases where wider than average characters are used, your tabular columns must be positioned far enough apart. Alternatively, you can print using a fixed-pitch font (such as Courier) to ensure that each character uses only one column.


Using the Print method, this example displays the value of the variable MyVar in the Immediate window. Note that the Print method only applies to objects that can display text.

Dim MyVar
MyVar = "Come see me in the Immediate pane."
Debug.Print MyVar
© 2018 Microsoft