Thread: Message Display
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Message Display

Barb,

In the VBIDE, hit Ctrl-G, you will see a small window pop-up. You can output
to this window i your code, using Debug.Print, or you can test something
directly in that window, using the ? operator, like breaking at a point in
the code and typing

?myVar

will display the current value of myVar

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Barb Reinhardt" wrote in message
...
Um ... what is the immediate window. I added it and see nothing.

"Ian" wrote:

debug.print x

This will print the variable x to the immediate window.

--
Ian
--
"Barb Reinhardt" wrote in

message
...
I'd like to display the results calculated within a macro in a message

box
in
order to debug the code. How would I do this? Alternatively, is

there a
better way to do this?

Thanks,
Barb Rienhardt