The main point is to try and separate view, data and calculation engine. PyXLL is great for helping with this as you can move the calculations into Python and

The main point is to try and separate view, data and calculation engine. PyXLL is great for helping with this as you can move the calculations into Python and thus have them automatically tested and protected by source control. I assume this is possible for VBA but have never seen it done in practice.