Phase angle spreadsheet VBA
In a previous post about a spreadsheet to show the superposition of two sine waves I used the ‘forms’ toolbar in MS Excel to produce a draggable phase angle slider. The graph of the two sine waves did not update dynamically as I moved the slider control.
Andrea J of www.allaboutoffice.co.uk has provided a VBA version of the phase angle spreadsheet that updates in real time as you drag the slider.
I had not thought of using a VBA slider control, and now I know that the VBA controls update dynamically, I’ll do more of these. Tip of the hat to Andrea and her colleagues.