When you’re trying to teach people how to use MS Excel, it helps to easily show them the formula. Instead of just moving the mouse to the cell and then looking at the contents of that cell, you can use a macro…
Found this over at http://en.kioskea.net/forum/affich-85224-excel-formula-display-in-cell
Create a personalized macro function in a new module :
Function DisplayFormula(cel As Range)
DisplayFormula = cel.Formula & ""
End Function
and after use this new function to the column B cells.
For example, if you want to display the A2 formula in B2, you have to write in B2 the following formula :
=DisplayFormula(A2)
Am saving a copy here in case the source website is offline.
In the future, I’ll add a video tutorial explaining how we added the DisplayFormula function to our MS Excel spreadsheet.
