What is the best way to learn VBA?

[Mangolili]

What is the best way to learn VBA if you know some VB?
Any recommendations for refreshing memories if VB is learned a few years ago? Thanks.

 

[JackDanIce]

Record some actions with the macro recorder and then review the code

 

[kpark91]

Answer VB questions on this forum
This really helped me alot.

 

[Desu Nota from Columbus]

I had zero experience with VBA prior to March 2011. I stumbled across this website accidentally and began to post questions pertaining to projects I was assigned at work.

I'm a very visual learner so for me, seeing something and then having a quick explanation to why, is enough for me to grasp the concept. This website along with google/wikipedia have been incredible in teaching me coding concepts and strategies.

I have learned something everyday for the last 3 months from this website just by reading another person's problem (and if I am unable to help) check back to see how the excel experts tackle the problem--from there, if I don't understand why something works I ask.

This strategy along with messing around with the macro recorder have been my substitute for classes and instructional books.

There are numerous tutorials on youtube and various websites as well.

For me though, I like to take the trial and error approach and then ask "why is this erroneous".

 

[Desu Nota from Columbus]

One additional comment:

I started with no foundation knowledge, so every function was new to me. I would pick a certain function and learn its applications and once I 'mastered' it, I would move on to the next one.

I've been adding a new function to my repertoire daily/weekly.

I try to help others as my skill set allows, and I often find that answers I submit to other work, but there are better and more concise ways of doing the same thing with another function------and this is what sparks me to learn new functions.

 

[Mangolili]

Thank you so much for all your replies. I really appreciate your advices.

 

[VoG]

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