I use 'Debug.Print "Text"' throughout many of my procedures so that I can see which procedures were activated, in which order, using which variables, and so on.

The procedures often call other procedures depending on user inputs and complete different loops. All the procedures have been set up to end in one Procedure which is used to 'Tidy up' and tasks done by the previous procedures.

I would like this final procedure to retreive the text from the immediate window (and copy it into an array for example for reviewing at any time).

Is this possible (without finding all of my 'Debug.Print' lines, and adding something like:

ListBox1.AddItem "text"

or

ImmediateWindowStringArray(BlankPosition) = "Text"   'declared globally
BlankPosition = BlankPosition + 1

TIA,


Tommy Long
Business Services Team
Barclays House, Dorset