returning to the "Display values behind formula" in excel 1

[ykantor1]

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/VBA/index.html

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

 

[ykantor1]

Hi
While googling, it was found at [URL unfurl="true"]http://www.geocities.ws/lalesyah/Download/index.html[/url] 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

 

[IDS]

I found it at:

http://www.reocities.com/SiliconValley/Hills/1829/VBA/index.html

with the download at:

http://www.reocities.com/SiliconValley/Hills/1829/Download/index.html

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/daily-download-15-evaluation-of-formulas-in-text/

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/

 

[ykantor1]

thank you Doug
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

 

[IRstuff]

Nothing is ever a problem to someone who hasn't done it yet; we just had a supplier finding that they couldn't actually do what they proposed.

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

Need help writing a question or understanding a reply? forum1529

 

[IDS]

The next step is to substitute the cell values instead of the cell addresses. Is that the problem?

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/

 

[ykantor1]

IRstuff - A limited function is still valuable for me ( and presumably for other users as well). i.e no aliases, no named ranges, just plain cell addresses.

Doug - the DISFOR function works fine.

regards

ykantor