garyrobbins
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
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
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
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.
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?
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
http://excel.tips.net/
You can also look at
www.vbtutor.net
Michael
ASKER
thanks for the suggestion. It led me to another online source for a VBA class:
http://vbaclasses.com/learn/
Gary
http://vbaclasses.com/learn/
Gary
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