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

M

maria28

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?
 
A

arno

Hi maria28,
always the
function (except from the formula bar) and not the result of the
function?
Click to expand...

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
 
G

Gary''s Student

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