Add immediate window ouptut (debug.print) to text box

[Kheribus]

Hello,

I have some processes in my user interface that take a bit of time (ie many operations), and I was wondering if I could create a popup/dialogue box that displays output from the immediate window (debug.print statements in my code).

This way, it will give the user an idea what is being processed while they are waiting for the code to finish execution.

Any ideas?

Thanks!

 

[speakers_86]

Of course you can. Just create an unbound text box and update it's value as needed. So instead of debug.print "text" you would say me.txtYourControlName = me.txtYourControl Name & vbcrlf & "text". Keep in mind that there is a limit to how much a control can hold, so eventually, you will have to set it's value without retaining the existing data there. I'm not sure how many characters it can hold.

 

[Kheribus]

Jesus christ that was a no brainer. It's 4:30pm here. Time for a beer.

Thanks