how can i do a (fx) visible in a cell

[Guest]

I am working on an excel sheet with functions(fx).
The functions i use are shown in the formula bar.
My question is what should i do to see in the cell always the function
(except from the formula bar) and not the result of the function?

 

[arno]

Hi maria28,

always the
function (except from the formula bar) and not the result of the
function?

this "function" of Excel VBA will show you always the formula of cell
"d":

Function myFormula(d As Range) As String
'gives the formula of cell "d"
If d.Cells.Count > 1 Then 'if you select more than one cell
myFormula = "Error: Refer to one cell only!" 'error message
Else
myFormula = d.Formula 'show the formula
End If
End Function

Place this "makro" in you workbook, in the sheets you use eg.
=myFormula(A1) to display the formula of cell A1.

arno

 

[Guest]

By typing CNTRL-TILDA you can toggle between displaying the formula and the
resutls of a formula in a cell