3 ms·
I wrote a VB macro that displays the formula for a cell, next to the cell. Granted you have to add a cell (typically a column) to make space for it. It returns
by analog31 2y ago
I wrote a VB macro that displays the formula for a cell, next to the cell. Granted you have to add a cell (typically a column) to make space for it. It returns either a formula, or "constant" if the cell doesn't contain a formula. I could make it more sophisticated, but just those two things are enough to make spreadsheets a lot easier for me to follow.
Following spreadsheets is like trying to find something in my garage if all of the boxes have lids. But if the boxes are all open, I can find stuff in a jiffy, even if the boxes are disorganized.
- accrual 2y agoThe closed toolbox is a nice analogy for opening a sheet full of numbers. A foreign Excel sheet can take a lot of clicking around to get an idea of how it works sometimes.
- keithalewis 2y agoControl-backtick toggles formulas. No need for VB(A).
- analog31 2y agoAh, I didn't know that. So I tried it. It does display formulas, but by hiding the values. What my macro does is allow the formula to be displayed permanently in its own column. Granted I'm one user out of many, and have switched to programming for any kind of quantitative work. but I'm still quite supportive of Excel.
- keithalewis 2y agoDo you realize it toggles data and formula display? That ought to be fine for anyone with more short term memory than a gnat.