Link to home
Create AccountLog in
Avatar of garyrobbins
garyrobbinsFlag for United States of America

asked on

Looking for your recommendation of an online class to learn VBA programming?

Hello Experts,
You guys are often recommending VBA solutions to the questions I have posed to you.  I'm ready to learn.  Could you recommend some online classes I could take to get started?

Thanks,
Gary
Avatar of jppinto
jppinto
Flag of Portugal image

I don't know of any good resources for learning VBA programming online but I would suggest that you start by buying a good book about VBA, practice the programming and when you have some doubts, that you search online for the subject that I'm sure that you will find answers. I bought recently this:

http://www.amazon.co.uk/VBA-Macros-Microsoft-MrExcel-Library/dp/0789743140/ref=sr_1_fkmr0_2?ie=UTF8&qid=1305796771&sr=8-2-fkmr0

"VBA and Macros", from Bill Jelen

It's very good and for you it's a good starting point.

You can also search Youtube and you will find many videos that teach some things about VBA but I don't know of any good video colection that gives you a complete course on this.

jppinto
ASKER CERTIFIED SOLUTION
Avatar of Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Flag of New Zealand image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Gary,

In my opinion the only way in the long run to learn VBA with Excel is to take small everyday problems with excel files and try to fix them. Although it might not be a bad thing to attent basic classes to get you started, you will achieve maximum return on investment if you focus on solutions close to your normal work process.

You could start by reading

http://www.excelfunctions.net/Excel-VBA-Tutorial.html

which gives you a basic overview of how you can use VBA in Excel.
LOL...if you live in San Diego, you can come to the free classes I'll be offering in June...otherwise, I haven't started my online classes yet, but might if I can find the right incentive...

Otherwise, I agree with AK

Do you need a document that explains the basic commands (kinda cheat sheet) of VBA?
Martin Green has some good tutorials at www.fontstuff.com.
If you do a Bingle search for "free excel vba tutorials" you'll find a lot of good references.
John Walkenbach has good pointers on his site: www.j-walk.com.
Excel MVP Ken Puls has some good stuff here: www.excelguru.ca.
Excel MVP Zack Barresse and I have some tutorials here: www.blog.smittypro.com.
If you want to get really in depth you can start browsing the MSDN Excel Programmer's Reference.

HTH
Another good resource for learning VBA is

http://excel.tips.net/

You can also look at

www.vbtutor.net

Michael
Avatar of garyrobbins

ASKER

thanks for the suggestion.  It led me to another online source for a VBA class:
http://vbaclasses.com/learn/

Gary