Teaching VBA programming
 

Hi all,

Sorry, it may be off-topic here, but I am going to teach a class of Excel
VBA programming on Finance. Most of the example programs are necessarily
long. Do you have any tips on presenting / teaching long programs in
classroom context? Or can you refer me to some websites which has resources
on teachiing (VBA) programming in general? Thanks a lot.

Frederick Chow
Hong Kong.

Teaching VBA programming
 

If you are teaching VBA, you should have a lot of short programs to show how the
object model works, how variables work, etc. You shouldn't try to teach VBA by
walking through a long existing VBA procedure. That's like teaching grammar by
making first graders read War and Peace.

Search for VBA classes, find an outline you like, and teach to it.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Microsoft Forum wrote:

Hi all,

Sorry, it may be off-topic here, but I am going to teach a class of Excel
VBA programming on Finance. Most of the example programs are necessarily
long. Do you have any tips on presenting / teaching long programs in
classroom context? Or can you refer me to some websites which has resources
on teachiing (VBA) programming in general? Thanks a lot.

Frederick Chow
Hong Kong.