returning to the "Display values behind formula" in excel
returning to the "Display values behind formula" in excel
(OP)
returning to the "Display values behind formula" in the faqs:
"Display values behind formula.
Download excellent VBA function disfor() from http://www.geocities.com/SiliconValley/Hills/1829/... The formula will look like actual handwriting, e.g. (5+6.3)/3."
The link has expired. Is there a working link?
Is there an alternative solution?
regards
ykantor1
"Display values behind formula.
Download excellent VBA function disfor() from http://www.geocities.com/SiliconValley/Hills/1829/... The formula will look like actual handwriting, e.g. (5+6.3)/3."
The link has expired. Is there a working link?
Is there an alternative solution?
regards
ykantor1





RE: returning to the "Display values behind formula" in excel
While googling, it was found at http://www.geocities.ws/lalesyah/Download/index.html but have not tried to use it.
Is there a way to verify that it is not a malware?
Is there an alternative solution?
regards
ykantor
RE: returning to the "Display values behind formula" in excel
http://www.reocities.com/SiliconValley/Hills/1829/...
with the download at:
http://www.reocities.com/SiliconValley/Hills/1829/...
I downloaded it and it doesn't seem to be malware (from a quick look)
Unfortunately it isn't open source.
You might find my Eval2 spreadsheet useful; here:
http://newtonexcelbach.wordpress.com/2012/10/01/da...
It doesn't do exactly what you asked for (which from a quick look doesn't seem to be a simple job), but what it does do is if you have a two columns with variable names, and associated values:
a 1
b 2
c 3
and a function entered as text:
= a + b + c
then it allows you to either evaluate the function, or display the individual values:
= 1 + 2 + 3
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: returning to the "Display values behind formula" in excel
It is OK and working.
Just for my curiosity- why "doesn't seem to be a simple job" ?
One may use:
Public Function DisplayFormula(rng As Range) As String
Displayformula = rng.Formula
End Function
and generate the formula with cell addresses and operators. The next step is to substitute the cell values instead of the cell addresses. Is that the problem?
(it is a pity that for me, it is a problem)
ykantor
RE: returning to the "Display values behind formula" in excel
Writing a robust parser is not a simple task. What if I used aliases for the cell addresses? Note that this macro does allow aliases, i.e., you can make a = z/y + x*z with the appropriate alias definitions, and the macro will still return the correct values.
TTFN

FAQ731-376: Eng-Tips.com Forum Policies
Need help writing a question or understanding a reply? forum1529: Translation Assistance for Engineers
RE: returning to the "Display values behind formula" in excel
Yes, extracting cell addresses and named ranges from a text string is not that straightforward.
Does the disfor function work OK? It seemed to, but I only had a quick look.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: returning to the "Display values behind formula" in excel
Doug - the DISFOR function works fine.
regards
ykantor