best way to learn VBA?

  • I have been coming to this forum for a little while, and love it.. I have learned soo much.. But honestly, my code still sux! LOL... I really want to learn this very effectively. I love writing it, but when I see some of the stuff you guys come up w/ I am in awe. Where would be the best place to go to learn all the ins and outs of vba. i get all the little email updates and read the forums daily. I really want to take a course though. Are the vba training classes offered on this site going to take me step by step on how to create the most effective code? I am really considering buying one of the training packages. Is there a better place for my lack of money to be spent learning this? Thanks for any suggestions!

  • Re: best way to learn VBA?

    Hi j,

    The best way to learn, IMO, is to try to answer questions in the forums. This gives you an almost endless source of problems to solve, covers a broad spectrum of topics and also enables you to see how others would tackle the same problem. (Note, you don't have to post your solutions if you don't want to, its the practice that is the key issue).

    Don't be afraid to make use of the F1 Help in the VBE and use the Macro Recorder to generate code where possible (too many people overlook these valuable sources of information).

    That said, its a bit of a 'hit and miss' approach if you are just starting off (I should know, that's how I started!) and you may find that you benefit from a more structured approach initially. Dave certainly knows his stuff and if you want some structure to your learning then that would be a good way to go. In the end it's up to your judgement - historically, what have you found is the best way for you to learn new material?

  • Re: best way to learn VBA?

    thanks richie! no doubt the best way for me to learn it is by doing! I try to solve some of the issues here, but sometimes I just don't understand what they're aiming for.. And there are only so many problems I can dream up for my own situations.

  • Re: best way to learn VBA?

    I highly recommend two books:

    Power Programming with VBA John Walkenbach

    VBA and Macros for MS Excel Bill Jelen and Tracy Syrstad

    Software: OpenOffice 3.0/NeoOffice 3.0 on Mac OS X 10.5.6
    Humanware: Older than dirt

    Old, slow, and confused - but at least I'm inconsistent!

    (retired Excel 2003 user, 3.28.2008)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!