Solved

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

Posted on 2014-10-15
5
156 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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 descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

734 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