bodmas.org

Phase angle spreadsheet VBA

Filed in Maths on May 31st 06 .

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.

This is filed under Maths. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are closed for this post.