Welcome to the new platform of Programmers Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use it's exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
Immediate Window Text Retrieval:
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:
ImmediateWindowStringArray(BlankPosition) = "Text" 'declared globally
BlankPosition = BlankPosition + 1
Business Services Team
Barclays House, Dorset