GetFormula Macro

Location: http://www.mvps.org/dmcritchie/excel/getformula.htm Home page: http://www.mvps.org/dmcritchie/excel/excel.htm [View without Frames]

GetFormula was my first User Define Function

I wrote GetFormula in 1997, to show the formula of another cell. GetFormula was written as a result of my first contact with an Excel newsgroup. Most of the help came from Alan Beban, who offered me a more complicated subroutine with offset. I managed to simplify it to a one line formula by trial and error to exactly what I really wanted in a more generic formula.
Having no manuals, I picked up all of the information from HELP. My introduction to macros was from Stephen Bullen, "you need a macro", so I looked in help to find out about macros in Excel, and what they looked like. Macros were a bit more intuitive in Excel 95 as you could see the macro on a macro sheet, so you knew exactly where to locate macros, user defined functions, and the HELP was in one place. With Excel 97 the Visual Basic Editor was accessed separately and had it's own help file.
The first reference of a working completed GetFormula was on Oct. 7, 1997, but I had called it ShowFormula earlier on Sept 14, 1997. ShowFormula is now used to show only a formula, when one exists.

The Code for GetFormula

Please refer to my Formula page "Show FORMULA of another cell in Excel" for GetFormula coding and variations, with examples, and more information. (code only)
Function GetFormula(Cell)
   GetFormula = Cell.Formula
End Function

Variations of GetFormula, also written by David McRitchie

[GetFormula] [GetFormula Example] [GetFormat] [GetText] [Ex] [Debug Format (notes) [HasFormula] [Ex] [BoldSum] [FontInfo] [FontStyle] [Select cells with formulas or constants] [UseFormula] [Formula in MsgBox] [Status Bar (description) moved] [GetFormulaInfo]

Related Functions by David McRitchie appearing on the Formula page

FontInfo, Function to show the font used in another cell, David McRitchie. i.e. Arial -- 10
GetFormat, Function to get the format of another cell, David McRitchie, below the coding are examples of custom formats used in formatting cells.
GetFormula, Function to get the formula of another cell, David McRitchie, also variations of this function -- GetFormulaI, GetFormulaD, ShowFormula. Excellent for documentation, because it is a working formula that is being documented.
GetText, Function gets the formatted text value from the referenced cell.
HasFormula, Function shows True if referenced cell has a formula, false otherwise, David McRitchie.
ShowFormula, Function to show the formula used in another cell but only if it is an actual formula (no constants), David McRitchie. GetFormula is preferred because it shows what was actually entered whether it was a constant or a formula.
UseFormula, Function to use the formula as written in text in another cell, David McRitchie, but usage of UseFormula is discouraged as GetFormula asseses the working formula. UseFormula wold fail if the text referenced turns out to not work as a formula. a valid

This page was introduced on January 11, 2003.

[My Excel Pages -- home] [INDEX to my site and the off-site pages I reference]
[Site Search -- Excel] [Go Back] [Return to TOP]

Please send your comments concerning this web page to: David McRitchie send email comments