Is there a way to acquire the information displayed in the Evaluate Formula box in Excel?
Sometimes, when evaluating a large or complex formula, the evaluation results displayed in the Evaluate Formula box is lengthy and requires scrolling to view in its entirety as shown in this example:
That, combined with the possibility of having multiple portions to evaluate, can make the process of understanding a particular formula quite cumbersome.
In the past I have typed out the displayed evaluation results by hand but that is a lengthy task and prone to errors and therefore not a good solution — especially for large or complex formulas.
I have tried (by mouse and keyboard) to select the evaluation results in order to Copy/Paste them into a Notepad file. I have also tried Right-clicking and anything else I could think of but without success.
If there is a way to capture evaluation results from the Evaluate Formula box — even if doing so is not possible directly in Excel but requires VBA, I would appreciate knowing how to do it.