Any recommended training resources for VBA programming (e.g. DVD, computer) for non-software people?

Question

I have been asked to find training resources to bring engineers up to speed on VBA programming.

The target trainee will have some systems engineering experience but little to no non-systems programming experience.

I'm hoping for a computer-based training course or DVD that we can purchase and give to the engineers for a couple days to bring them up to speed with the basics.

Unfortunately, my Google-fu is having a hard time cutting through the marketing sites to any obviously credible information.

Any feedback on good (or bad) resources would be much appreciated.

---

Edit: the engineers will be applying their new VBA skills in non-Office products.

While reference materials are useful, I really need something that guides them through the basics.

Answer 1

the best training program for VBA is the Macro Recorder. Pick something that you want to understand then record doing it in the GUI and look at the generated code.

Edit [haren]: my preferred answer was in the comments to this answer (thanks EBGreen!):

There really isn't any great documentation. There are some good sample websites. If you want structured instruction, you may be better off looking for VB6 instructional materials then learning the relatively few differences. – EBGreen (Dec 2 at 15:18)

Answer 2

Until you get a good commercial DVD or other resources you can try these series of videos available at youtube.

Microsoft Excel 2007 VBA training courses and free online tutorials

You can use one of the availalbe youtube downloader to download these videos. You will also find other helpful VBA videos in the recommended links provided.

Hope you find this useful.

Answer 3

Beware of the macro recorder, some of the code generated is old and deprecated. The VBA help files, available from the code window, are very good indeed and the object browser is very useful.