Solved

Copy, export or print results from Evaluate Formula box in Excel

Posted on 2014-10-15
5
150 Views
Last Modified: 2014-10-30
Hello,

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.

Thanks
0
Comment
Question by:WeThotUWasAToad
5 Comments
 
LVL 27

Assisted Solution

by:Glenn Ray
Glenn Ray earned 133 total points
ID: 40382851
That's certainly a feature I'd like to see - heck, even an option to enlargen the evaluate formula box would be nice.  But, unfortunately, there is no way to extract displayed results (besides a screen cap like you did).

-Glenn
0
 
LVL 23

Assisted Solution

by:Danny Child
Danny Child earned 67 total points
ID: 40382945
Some screen capture programs (like Snag It) have options to capture text, instead of just an image.  It may work... but sometimes it garbles the output.

Is there a way to make your formulas less horrific?
0
 
LVL 27

Assisted Solution

by:Glenn Ray
Glenn Ray earned 133 total points
ID: 40383081
They may not be "horrific" formulas; some array formulas are quite elegant actually, but may involve the evaluation of hundreds or thousands of equations in order to work.  That's what this formula appears to be, in fact.
0
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 300 total points
ID: 40383758
There is no direct VBA access to the Evaluate formula text - probably because it wouldn't run while the dialog was invoked anyway. However, you can select portions of the formula in the formula bar and press f9 to evaluate them inline with the formula. This text can be copied.

heck, even an option to enlargen the evaluate formula box would be nice

It has been asked for many times!
0
 

Author Closing Comment

by:WeThotUWasAToad
ID: 40414274
Thanks
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question