[vba] Where does VBA Debug.Print log to?

Where does Debug.Print output messages?

This question is related to vba debugging ms-office

The answer is

Where do you want to see the output?

Messages being output via Debug.Print will be displayed in the immediate window which you can open by pressing Ctrl+G.

You can also Activate the so called Immediate Window by clicking View -> Immediate Window on the VBE toolbar

enter image description here

Debug.Print outputs to the "Immediate" window.

Debug.Print outputs to the Immediate window

Also, you can simply type ? and then a statement directly into the immediate window (and then press Enter) and have the output appear right below, like this:

simply type ? and then a statement directly into the immediate window

This can be very handy to quickly output the property of an object...

? myWidget.name

...to set the property of an object...

myWidget.name = "thingy"

...or to even execute a function or line of code, while in debugging mode:

Sheet1.MyFunction()

Source: Stackoverflow.com

Examples related to vba

• Copy filtered data to another sheet using VBA • Better way to find last used row • Check if a value is in an array or not with Excel VBA • Creating an Array from a Range in VBA • Excel: macro to export worksheet as CSV file without leaving my current Excel sheet • VBA: Convert Text to Number • What's the difference between "end" and "exit sub" in VBA? • Rename Excel Sheet with VBA Macro • Extract Data from PDF and Add to Worksheet • Quicker way to get all unique values of a column in VBA?

Examples related to debugging

• How do I enable logging for Spring Security? • How to run or debug php on Visual Studio Code (VSCode) • How do you debug React Native? • How do I debug "Error: spawn ENOENT" on node.js? • How can I inspect the file system of a failed `docker build`? • Swift: print() vs println() vs NSLog() • JavaScript console.log causes error: "Synchronous XMLHttpRequest on the main thread is deprecated..." • How to debug Spring Boot application with Eclipse? • Unfortunately MyApp has stopped. How can I solve this? • 500 internal server error, how to debug

Examples related to ms-office

• How to read data from excel file using c# • Excel 2007: How to display mm:ss format not as a DateTime (e.g. 73:07)? • What do <o:p> elements do anyway? • Access Database opens as read only • Microsoft.Office.Core Reference Missing • What is a correct MIME type for .docx, .pptx, etc.? • VBA: How to display an error message just like the standard error message which has a "Debug" button? • How to detect installed version of MS-Office? • How can I programmatically freeze the top row of an Excel worksheet in Excel 2007 VBA? • Where does VBA Debug.Print log to?

[vba] Where does VBA Debug.Print log to?

The answer is

Examples related to vba

Examples related to debugging

Examples related to ms-office

Tags