PDA

View Full Version : Debugging - Show workbook if code running on memory?



youngmcc
04-08-2011, 07:07 AM
Hi

I have some code that I am trying to debug, however, it all runs on the system memory and only spits out an output at the end of the code.

I am looking to have the workbook shown in the background so I can see what is going on as I step through the code.

I am pretty sure you can put a command in the immediate window or similar to do this?

Can anyone help?

Thanks

Kenneth Hobs
04-08-2011, 07:33 AM
Sub t
dim x as string
x="Hello World!"
debug.print x 'result to Immediate Window
End Sub

youngmcc
04-08-2011, 07:39 AM
Sub t
dim x as string
x="Hello World!"
debug.print x 'result to Immediate Window
End Sub

Hi Ken,

I am more interested in seeing the workbook in the background?
Is that possible?

I know its not normal practice for debugging, however, have come up against a problem that I need to see whats being put together on the worksheet itself.

Thanks

GTO
04-08-2011, 07:58 AM
Reduce VBIDE to about a third of screen, fill the remainder of screen with the workbook and step through the code.

DOes that help?