Back in the day, we used to need to write a full macro (also called User-Defined-Function) to allow users to show the formula from a certain cell
Not any more
Excel 2013 (Excel 365 or Excel 2016) comes with the new formula FORMULATEXT()
This beautiful one, just shows the formula from a cell.
Get it from Sheet2 in attached spreadsheet