I would like to set up some kind of an "output window" for debugging
purposes that would behave like a calculator tape. I could write a
little subroutine that would cause a text string to be displayed on
the next line in that window so I could follow what's happening in the
program. I would then insert calls to the subroutine at various places
in the code like this:

...
Call DebugWindow("XYZ routine..."
...
Call DebugWindow("i=" & i)
...

Can someone point me in the right direction to get started on this?

Is there a better way to accomplish this?

Thanks


--
For email, use Usenet-20031220 at spamex.com

Re: Calculator tape debug window by Jonathan

Jonathan
Tue Jun 29 08:25:49 CDT 2004


"Top Spin" <ToppSpin@hotmail.com> wrote in message
news:o0q2e01jhok55v24qqin63p9srb9qmvhta@4ax.com...
> I would like to set up some kind of an "output window" for debugging
> purposes that would behave like a calculator tape. I could write a
> little subroutine that would cause a text string to be displayed on
> the next line in that window so I could follow what's happening in the
> program. I would then insert calls to the subroutine at various places
> in the code like this:
>
> ...
> Call DebugWindow("XYZ routine..."
> ...
> Call DebugWindow("i=" & i)
> ...
>
> Can someone point me in the right direction to get started on this?
>
> Is there a better way to accomplish this?

In the VBA editor, press Ctrl-G to open the Immediate window. This does
exactly what you are asking for.

Within your program you can use the Debug.Print command to print value to
the immediate window. You can also do on-the fly calculations and commands
by typing in the immediate window.


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup


Re: Calculator tape debug window by Top

Top
Tue Jun 29 21:34:00 CDT 2004

On Tue, 29 Jun 2004 14:25:49 +0100, "Jonathan West" <jwest@mvps.org>
wrote:

>Within your program you can use the Debug.Print command to print value to
>the immediate window. You can also do on-the fly calculations and commands
>by typing in the immediate window.

Debug.Print does exactly what I wanted. Thank you.

--
For email, use Usenet-20031220 at spamex.com