Solved

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

Posted on 2014-10-15
5
167 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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

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.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

617 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