PDA

View Full Version : Good online tutorials/Where do you learn vba from?



cavemonkey
05-27-2007, 11:55 PM
Hi all

I'm just wondering if there are any good online resources that I can refer to when it come to writing up a vba code. With no piror training or knowledge in programming, I find it really hard to write up and debug my own code. And I feel very limited as I only know 1 or 2 statement, which I know is inadequate in writing up a good code.

So I'm addressing this to all of you guys out there. Is there any good online resources to recommend? thanks.

Aussiebear
05-28-2007, 01:08 AM
Yes, right here.

Click on Site Links, Training and go from there. Are you sure its vba training that you need or perhaps more of the object layer training?

cavemonkey
05-28-2007, 08:31 AM
object layer training? what's that?

Bob Phillips
05-28-2007, 09:15 AM
The Excel object model. Some people need to learn VBA, its syntax and its constructs. Others might know this part, but not how to use it in relation to the Excel product.

Cyberdude
05-28-2007, 01:08 PM
Hi, cavemonkey!

I gotta say that you should have at least one good (thick) Excel reference book. I've always like the books by John Walkenbach. I can vouch for the one called "Excel 2003 Power Programming with VBA". Go to Amazon.com and search for a list of Walkenbach's books. They usually cost between $20 and $30, and worth every penny.

Another good reference for specific items is the Excel and VBA Help files. In VBA, just put your cursor over the item of interest and press F1.

And, of course, come to this forum with specific questions.

Sid

cavemonkey
05-28-2007, 05:08 PM
hmm...ok thanks alot. Heard from other people saying the help for excel vba is quite useful. For once microsoft help option is doing its purpose.

YellowLabPro
05-29-2007, 05:30 AM
A list of things that have helped me:
1)The VBA Training and Certification that VBAExpress offers.
2)VBA for Dummies by J.Walkenbach, Not the big book- you will not need it now
3)A short list for you to reference.

Here is a good online site/article:
http://www.tushar-mehta.com/excel/vba/
http://www.tushar-mehta.com/excel/vba/vba-Understand%20code.htm
http://www.angelfire.com/biz7/julian_s/julian/julians_macros.htm

And on the funnier side:
VBA is called OOP, or Object Oriented Programming.
After studying this for a few months now, I don't think they could have come up w/ a better name for VBA, everrrrrr.
When I am writing a piece of code and it does not work or the syntax is wrong... VBA sends me an error message stating:
I Object!
And then I have to rethink my (Argument) and most times I get another scolding message box- I Object.... :rofl:
And so I have to turn to my co-counsel here on VBAexpress for their knowledge and assistance...
And that is how VBA got called an OOP language....

Good luck Cavemonkey,

YLP

Neodubois
05-29-2007, 08:30 AM
Thanks for the links

johnske
05-30-2007, 08:17 PM
For a really good online link to get you started and answer many questions, try http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/office97/html/web/FULLTOC.asp

YellowLabPro
05-31-2007, 05:21 AM
Thanks John.
Is there a way to navigate from chapter to chapter automatically in the word doc. layout w/out having to go back to the folder and open each chapter individually?

johnske
05-31-2007, 05:32 AM
Thanks John.
Is there a way to navigate from chapter to chapter automatically in the word doc. layout w/out having to go back to the folder and open each chapter individually?Sorry YLP -no :)

YellowLabPro
05-31-2007, 05:35 AM
Thanks John,
No worries, was not sure if there was a method to do this that I was not aware of.

Thanks for sharing all that good stuff. Will come in very helpful.

YellowLabPro
06-02-2007, 05:44 AM
One more to add for reference:
I found this looking for info on Intellisense:
http://www.design-drawing.com/visio/kgvbaide.htm
Don't let the title push you off, it has some good reference material.

Bob Phillips
06-02-2007, 05:56 AM
Those are dire images he has got there.

unmarkedhelicopter
06-02-2007, 08:32 AM
Well, I could read the first one ... the rest ... ???

paulked
06-02-2007, 11:05 AM
Pipe it through to your 72" widescreen TV for a small chance :thumb