Can someone please explain how to setup GETFORMULA() in EXCEL 2003? thanks...
--
"Bright minds are blessed to those who share them.."-rsb.

thanks again....is this function will not cause any trouble say like a
volatile one...
--
"Bright minds are blessed to those who share them.."-rsb.


"Anthony D" wrote:

Glad it works, thank you for your feedback.
David McRitchie gives the following examples:

=GetFormula(A1) -- Display the formula used in cell
A1
=GetFormula(sheet150!A1) -- get the formula used on another
worksheet
=GetFormula([WBName.xls]WSName!A1) -- from another workbook with
caution

Anthony

"romelsb" wrote:

would this module good to get formula from another worksheet or even from
another workbook?
--
"Bright minds are blessed to those who share them.."-rsb.


"Anthony D" wrote:

Hi Romelsb,

Would this link be helpful ?
http://www.mvps.org/dmcritchie/excel/formula.htm
giving the code for GetFormula as a User Defined Function.
This may be entered via Tools, Macro, Visual Basic Editor, Insert Module.

Function GetFormula(Cell as Range) as String
GetFormula = Cell.Formula
End Function


Regards
Anthony

"romelsb" wrote:

Can someone please explain how to setup GETFORMULA() in EXCEL 2003? thanks...
--
"Bright minds are blessed to those who share them.."-rsb.

Not sure if this is the meaning of volatile you are referring to ?
The default is that a user defined function (UDF) is volatile -
"The function will be recalculated whenever calculation occurs in any cells
on the worksheet on which this function appears."
A UDF can be set to be non-volatile instead:

Function GetFormula(Cell as Range) as String
Application.Volatile(False)
etc.

Hth
Anthony
ps (going offline now, back tomorrow)

"romelsb" wrote:

thanks again....is this function will not cause any trouble say like a
volatile one...
--
"Bright minds are blessed to those who share them.."-rsb.


"Anthony D" wrote:

Glad it works, thank you for your feedback.
David McRitchie gives the following examples:

=GetFormula(A1) -- Display the formula used in cell
A1
=GetFormula(sheet150!A1) -- get the formula used on another
worksheet
=GetFormula([WBName.xls]WSName!A1) -- from another workbook with
caution

Anthony

"romelsb" wrote:

would this module good to get formula from another worksheet or even from
another workbook?
--
"Bright minds are blessed to those who share them.."-rsb.


"Anthony D" wrote:

Hi Romelsb,

Would this link be helpful ?
http://www.mvps.org/dmcritchie/excel/formula.htm
giving the code for GetFormula as a User Defined Function.
This may be entered via Tools, Macro, Visual Basic Editor, Insert Module.

Function GetFormula(Cell as Range) as String
GetFormula = Cell.Formula
End Function


Regards
Anthony

"romelsb" wrote:

Can someone please explain how to setup GETFORMULA() in EXCEL 2003? thanks...
--
"Bright minds are blessed to those who share them.."-rsb.

No idea.

I'm not sure that it's a standard function. What's it supposed to do?


Greg



romelsb wrote:
Can someone please explain how to setup GETFORMULA() in EXCEL 2003? thanks...
--
"Bright minds are blessed to those who share them.."-rsb.

Maybe you're referring to this?

http://www.andrewsexceltips.com/menu...et_formula.htm


romelsb wrote:
Can someone please explain how to setup GETFORMULA() in EXCEL 2003? thanks...
--
"Bright minds are blessed to those who share them.."-rsb.

I would not include VOLATILE in the function, you can use F9
to recalculate the sheet. After all it is a debugging/documentation tool.
If you change the referenced cell
then the function will recalculate. as long as Calculation is turned on.

Documentation is at http://www.mvps.org/dmcritchie/excel/formula.htm
sorry if that was already mentioned, I lost my copies of these newsgroups last
night and decided to just add new messages without re-obtaining the old
messages.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"romelsb" wrote in message ...
thanks again....is this function will not cause any trouble say like a
volatile one...
--
"Bright minds are blessed to those who share them.."-rsb.


"Anthony D" wrote:

Glad it works, thank you for your feedback.
David McRitchie gives the following examples:

=GetFormula(A1) -- Display the formula used in cell
A1
=GetFormula(sheet150!A1) -- get the formula used on another
worksheet
=GetFormula([WBName.xls]WSName!A1) -- from another workbook with
caution

Anthony

"romelsb" wrote:

would this module good to get formula from another worksheet or even from
another workbook?
--
"Bright minds are blessed to those who share them.."-rsb.


"Anthony D" wrote:

Hi Romelsb,

Would this link be helpful ?
http://www.mvps.org/dmcritchie/excel/formula.htm
giving the code for GetFormula as a User Defined Function.
This may be entered via Tools, Macro, Visual Basic Editor, Insert Module.

Function GetFormula(Cell as Range) as String
GetFormula = Cell.Formula
End Function


Regards
Anthony

"romelsb" wrote:

Can someone please explain how to setup GETFORMULA() in EXCEL 2003? thanks...
--
"Bright minds are blessed to those who share them.."-rsb.