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