Best way to learn VBA

[simoran2]

Hi there

I am a relatively confident excel user - most tasks I can find a non VBA solution. Every now and then though there will be something that can only be achieved through VBA and it occurs to me in general it would be a nice addition to my skill set.

So with that in mind can someone point me in the right direction to start learning about VBA? I literally know nothing so am starting from the start

Any help you can give as always is appreciated!

Thanks

Simon

 

[VoG]

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

 

[CWatts]

The single best way to learn in my opinion is to use the macro recorder built into excel. Start recording, do some stuff, and then stop recording and check out hte code that it generates. That'll give you a feel for some of the stuff it does.

Other than that, I'd suggest stepping through some some dummies books or other vba books (Mr. Excel himself has one available).

After a while, check out the problems people on the board post and see if you can find a VBA solution for their problems. Granted a lot of the guru's will beat you to a response, but you get the benefit of figruing it out yourself as well as seeing different ways to do things.

That's the route I took, hope it works for you.

Edit: See what I mean about the guru's beating you to responses? :P

 

[chuckles1066]

Hi there

I am a relatively confident excel user - most tasks I can find a non VBA solution. Every now and then though there will be something that can only be achieved through VBA and it occurs to me in general it would be a nice addition to my skill set.

So with that in mind can someone point me in the right direction to start learning about VBA? I literally know nothing so am starting from the start

Any help you can give as always is appreciated!

Thanks

Simon

This site is as good as it gets.

You'll get hundreds of code examples for free every day just by browsing the forum.

Use them, experiment with them, save them, it's a great way to learn.