Excel VBA WS Overview

							Excel VBA WS Overview

References for VBA

Robert de Levie      Advanced Excel for scientific data analysis              Oxford 2004
       (around $60 in paper).

       Exellent discussion of VBA and something of its evolution.

       Tons and tons of good examples

       Tons and tons of useful routines already debugged, downloadable from Oxford's site
              www.oup-usa.org/advancedexcel

Paul Kenton's VBA site        www.vbaphysics.com

       Course notes for Computer Applications in physics.

       A huge treasure of VBA instruction, mixed with physics problems and examples.

       He writes it's fine to use his stuff, but if any financial gain is involved, he should be
       compensated.

Kimmel, Green, Bullen, Bovey, Rosenberg and Patterson. Excel 2003 VBA Programmer's Reference

       Wiley Publishing, 2004

       Gets into the guts of VBA. Lots of stuff you won't need and quite a bit that could be useful if
       you need to do special stuff.




Matrices Gee-Whiz examples
       Euler angles
       Transmission coefficients

       Simple Matrix activity for participants (1-D rotation matrix)

Justin Kay Video Analysis
        Discuss some features of the code briefly
        Object Browser

VBA Gee-Whiz examples (brief show-and-discuss)
     FFT from de Levie
       pick N to be analyzed (slider)
       pick start point in data (slider)
       do the FFT
       transfer data to top where it is plotted

Graph innards
       square graph
       scroll through data with a slider (change max and min with sliders)

VBA loops (loop over frequency for a graph of transmission coeff vs. freq)