Where does VBA Debug.Print log to?

Question

Where does Debug.Print output messages?

[specific to the Visual Basic for Applications (VBA) Language Reference for Office](http://msdn.microsoft.com/en-us/library/gg278865(v=office.14).aspx) — , Oct 23 '14 at 09:43

score 408 · Accepted Answer · edited Apr 30 '14 at 07:23

408

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

edited Apr 30 '14 at 07:23

answered May 26 '10 at 20:07

Dirk Vollmar

172,527
53
255
316

10

This is true if you are in an office application which supports VBA, but if you are using via WSH you may need to use MsgBox (*shudder*) or some similar technique as the immediate window is not available. – AJ. May 26 '10 at 20:09

LimaNightHawk · Answer 2 · 2015-09-24T21:06:58.783

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

Where does VBA Debug.Print log to?

2 Answers2

Linked