Learning VBA

[Wondering Nomad]

I'd like to learn to use VBA but am having a hard time learning from a book. Does anybody know of any online lessons, traditional schools, or any other place that may offer instructor led classes on VBA?

Or, did everybody teach themselves?

 

[Smitty]

Welcome to the Board!

Do a Google search for "Free Excel VBA Tutorials".

The MSKB is also a great place to take a look.

As is the Microsoft Visual Basic Programmer's Guide

As for if folks taught themselves, I believe that many of us old farts did. I can't speak for the young 'uns.

Remember, the Macro Recorder is your friend.

HTH,

Smitty

 

[ExcelChampion]

I don't know where you are from, but if in or near the U.S.A. there is a learning center called New Horizons that offer VB courses. However, be aware that these courses can run over $1000 per course.

If you have enough initiative, you can absolutely teach yourself. As Smitty said, use the macro recorder. Record a couple of steps and then look at the code. Then start trying to modify the code. Once you learn how ranges and such are supposed to look, then start learning about loops and error trapping.

And as always, hang out on the Excel forums. One of the best ways to learn is to try to figure out a solution for other people's issues.

HTH!