Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Showing Formula
Hello
I have a cell calculate based on info from other cells. How do I make the cell show the formula when selected instead of the hardcoded result? Thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Showing Formula
Hi JV.
Try: Public Function MyValue(aCell As Range) As Variant by Norman Jones in m.p.i.o.e Dim myVal As Variant myVal = Replace(aCell.Formula, Application. _ International(xlDecimalSeparator), ".") myVal = Evaluate(myVal) If IsError(myVal) Then MyValue = CVErr(xlErrNA) Else MyValue = myVal End If End Function in A1: D1+E1*F1-10 in B1: =MyValue(A1) Regards Eliano "JV" wrote: Hello I have a cell calculate based on info from other cells. How do I make the cell show the formula when selected instead of the hardcoded result? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula showing in cell rather than answer for formula | New Users to Excel | |||
How to fix my spreadsheet from showing formula to showing answer | Excel Discussion (Misc queries) | |||
How to fix my spreadsheet from showing formula to showing answer | Excel Discussion (Misc queries) | |||
Formula Showing Zero instead of nothing | Excel Discussion (Misc queries) | |||
formula not showing up | Excel Programming |