3 ms·
Part 3 A few weeks ago I wrote a simple fuel saving device feasibility calculator. I whipped off the Excel version in a couple of hours…. Then, I tried to do al
by brucebadeau 16y ago
Part 3
A few weeks ago I wrote a simple fuel saving device feasibility calculator. I whipped off the Excel version in a couple of hours…. Then, I tried to do all the calculations inside controls using VBA code, placing output in text boxes… OMG … this “simple” experiment turned into a long nightmare… What we take for granted with Excel – i.e. dependent relationships being automatically programmed is NOT done in VBA… I had to place code in every dependent control (SpinButtons) to calculate several text boxes and to carefully format them both numerically and graphically … like Green Boxes for Positive Numbers and Pink for Negative Numbers… Now I should have call up a module and avoided duplication, bu nonetheless, this was a tough edit… Spinning numbers in and seeing if every text box that should have registered movement actually did…