Clever Geek Handbook

Any recommended learning resources for VBA programming (e.g. DVD, computer) for non-programmers?

I was asked to find training resources to get engineers up to speed when programming VBA.

The target trainee will have some experience in systems engineering, but little to no programming experience without systems.

I'm hoping for a computer training course or DVD that we can purchase and give the engineers a couple of days to get them in order with the basics.

Unfortunately, my google-fu has a hard time slicing marketing sites with any obvious credible information.

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

Edit: Engineers will be applying their new VBA skills to non-Office products.

While the reference material is helpful, I really need something to guide them through the basics.

+1


source to share


3 answers


the best tutorial for VBA is Macro Recorder. Select what you want to understand and then take a GUI entry and look at the generated code.

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



There really isn't much documentation. There are good examples of sites. If you want structured learning, you might be better off looking for VB6 tutorials, then learning for relatively few differences. - EBGreen (December 2 at 15:18)

+2


source


Until you get a good commercial DVD or other resources, you can try this series of videos available on youtube.

Microsoft Excel 2007 VBA Tutorials & Free Online Tutorials



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

I hope you find it helpful.

+2


source


Beware of the macro corrector, some of the generated code is outdated and out of date. The VBA help files available from the code window are very good and the object browser is very helpful.

+2


source






More articles:


All Articles