Where does VBA Debug.Print log to?

VbaDebuggingMs Office

Vba Problem Overview

Where does Debug.Print output messages?

Vba Solutions

Solution 1 - Vba

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

Solution 2 - Vba

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()

Categories
Recommended Vba Solutions
Recommended Debugging Solutions
Recommended Ms Office Solutions

Previous Solution:

How do I work with a git repository within another repository?

GitGit SubmodulesMultiple Repositories

Next Solution:

DatabaseError: current transaction is aborted, commands ignored until end of transaction block?

PythonDjangoPostgresqlPsycopg2

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionAlex GordonView Question on Stackoverflow
Solution 1 - VbaDirk VollmarView Answer on Stackoverflow
Solution 2 - VbaLimaNightHawkView Answer on Stackoverflow