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 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.

Comments are closed.