| Filed under: General |
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 & ""
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 :
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.
“Yes, I Want To Grow My Financial Life & Get The 11 TrulyRichClub Blessings!”
To Grab This Offer, Click Option Below:secret to making money online... click the LIKE button below, and we will publish more of the content that YOU want. Thanks!
First posted on Tuesday, 09 Jul 2013