VBA code (and macro) help and tutorial?

**johnt83** · 03-31-2011, 06:14 PM

Is there a website and/or youtube video(s) that you could suggest where we can learn VBA code? All about variables and actually writing code? For beginners?

I have seen many websites but none of them really give a breakdown of what the variables mean or how to write a program using fresh code (from scratch), something simple to something complex.

I would like to learn more about how to automate tasks associated with reporting, including using macros. Thank you for your help.

**stnkynts** · 03-31-2011, 06:23 PM

VBA for Dummies.
Anything from John Walkenbach.

**johnt83** · 03-31-2011, 06:40 PM

Originally Posted by stnkynts

VBA for Dummies.
Anything from John Walkenbach.

Thanks for the book suggestion

Do you have websites and/or video recommendations as well?

**tigeravatar** · 03-31-2011, 07:00 PM

I don't really have any website/video recommendations, but I have found the Record Macro utility to be tremendously useful for learning VBA.

**johnt83** · 03-31-2011, 07:10 PM

Thanks

I will try playing around with the Record Macro function and see what code gets generated, although from what I have heard it isn't really efficient code, but it will help some.

**broro183** · 03-31-2011, 08:34 PM

hi Johnt83,

Adding to the previous comments:
- I would second the support of Walkenbach's books. I have found them very useful & easy to read too which is always a bonus

- Some of the code from the macro recorder isn't terribly efficient but, provided your specific actions can be recorded, the recorder can help greatly by providing samples of the correct syntax. These samples can then be optimised as you learn how. Also, after selecting a word or phrase of recorded code in the VBE you can press [F1] to bring up the relevant Help file.

You may find the links in the below post help you on your journey of self guided discovery...
http://www.excelforum.com/2411485-post4.html

hth
Rob