Where does Debug.Print output messages?
-
specific to the Visual Basic for Applications (VBA) Language Reference for Officeuser2140173– user21401732014-10-23 09:43:19 +00:00Commented Oct 23, 2014 at 9:43
-
wallstreetmojo.com/vba-debug-printGenDemo– GenDemo2021-04-14 01:56:23 +00:00Commented Apr 14, 2021 at 1:56
Add a comment
|
2 Answers
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
1 Comment
AJ.
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.
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:
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()
