Teaching VBA programming

  • Thread starter Thread starter Microsoft Forum
  • Start date Start date
M

Microsoft Forum

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.
 
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/
_______
 
Back
Top