Here is where the magic of VBA (Virtual Basic for Applications ... When you make changes to the specific cell range, the function updates the final value automatically. You can always calculate ...

The only other way around this sometimes laborious process is to write a VBA macro ... In my case, I want the spin button in cell E2 to link to the value in D2. Then, complete the remaining ...