Determining if cell contains formula or value

[tapeery]

I have a cell that contains a formula, but users can override it b
entering a value, if necessary.

I need to determine whether the cell contains a formula, or if th
formula has been overwritten by a value.

How would I do this?

Alternately, is there any way to extract the formula from a cell, an
treat the formula a text?

Thanks for any thoughts

 

[Jason Morin]

See:

http://www.mvps.org/dmcritchie/excel/formula.htm

HTH
Jason
Atlanta, GA

 

[Frank Kabel]

Hi
you may try the following UDF (put in a module of your workbook)

Function is_formula(rng As Range)
is_formula = rng.HasFormula
End Function

use it like
=IS_FORMULA(A1)

Note: not much error checking included (e.g. multiple cells as range
parameter, array formulas, etc.).