Best way to learn VBA for Excel

[Svea]

Dear all,

I am advanced user of Excel, still beginner regarding VBA.
Would like to learn it at home and wondering - what is the best way to do it?
Which book would you recommend? Or do you maybe now for some video lessons I could take?

Thank you so much for your help!

Regards,
Svea

 

[Smitty]

Welcome to the Board!

If you do a Google/Bing search for "Free Excel VBA Tutorials" you'll get a lot. You can start with Martin Green's www.fontstuff.com.

Probably the best way to start getting the hang of VBA is to start recording some macros performing everyday tasks with which you're familiar, then start reading the code. If you're familiar with the process you're recording the code will make more sense than if you do something new.

And always feel free to post your questions here.

HTH,

 

[VoG]

Also, take a look at Hiker's List http://www.mrexcel.com/forum/showpost.php?p=2676997&postcount=5