Re:Make up your own rules of probability
by brucebadeau on Wednesday February 02, 2011 @10:03PM
(#2173362)
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…
[ Parent
| on HN ]
There are no comments on this comment yet.