VBA Programming

[RichSA]

Hi,

I am wanting to learn VBA and thought of buying the Excel Power Programming book but I have excel 2010 version on my work Laptop and was wondering if I should go for the Excel Power Programming 2013 as its a newer release of the book even though my work has not upgraded the pc's to 2013 yet.

Is there a big difference that I will confuse myself trying to use the Excel Power Programming 2013 book with excel 2010 version? I just don't want to learn vba for 2010 and then have to learn again vba for 2013 as there might be big changes?

Would love to here your views.

RichSA.

 

[Joe4]

Welcome to the Board!

Typically, there aren't big changes in VBA from version-to-version, so I don't think you would need to worry about it. If you learn VBA using 2010, you will not having any problems using it in 2013 especially since 99% of the time, things that worked in older version work fine in newer versions (the biggest exception was 2003 to 2007, when they took away some functionality).

 

[RichSA]

Welcome to the Board!

Typically, there aren't big changes in VBA from version-to-version, so I don't think you would need to worry about it. If you learn VBA using 2010, you will not having any problems using it in 2013 especially since 99% of the time, things that worked in older version work fine in newer versions (the biggest exception was 2003 to 2007, when they took away some functionality).

Thanks for your advice, I will then go ahead and purchase 2010's book.

 

[Dotun Paul]

Hi,

Please I want to learn VBA in excel.
How do I get started please.

I need this urgently.

Regards

 

[Joe4]

Please I want to learn VBA in excel.
How do I get started please.

I need this urgently.

It is not something you are just going to learn overnight. There are many layers to it, and you can go as far as you like. As to the "urgency" of your request, how fast your learn really just depends on how much time and effort you are willing to commit to learning this.

There are many ways to learn:
- take a class at a local college or professional development center
- work through some on-line tutorials
- get some good introductory books

Hiker95 has an extensive lists of resources that can help with this.
See: http://www.mrexcel.com/forum/excel-...hen-compare-other-values-row.html#post4161527

Also note that the Macro Recorder is a good tool for learning some VBA. You can record yourself performing some basic tasks in Excel, then view the VBA code that it creates.
See: Excel Macro Recorder - Excel VBA Easy

 

[rbion]

Joe4 has listed some good ways to learn VBA programming but I've noticed that there aren't very many colleges offering VBA courses anymore. Are local colleges offering something else in place of VBA now? As a beginner who has used books and online tutorials, I'd love to learn in-class without the higher expense of going through a professional development centre. At one point I thought Visual Studio was a replacement for VBA but have since learned this is not the case. (If a new discussion for this should be started, please let me know and I'll remove this and repost). Thanks.

 

[Smitty]

Welcome to the Board!

You're not going to find too many courses for VBA at the college level, although the different languages included in Visual Studio will be part of many computer science classes. I teach an Excel class at a local university as part of the extended studies program, and do cover VBA, but not extensively. In that setting, there's just not enough call for it vs. general Excel knowledge.

I think you'll do fine with books and what you can find online. Most VBA experience comes from simply using it in your environment. Although a good background in computer programming/science principles and logic (something I never had) certainly wouldn't hurt.

 

[KenWit]

John Walkenbach's 2010 excel power programming book was a great read. The best book I've read on the subject. Very comprehensive. Not sure about the 2013 one. Take the advice above I'd say.

A good way to learn is just to set about trying to accomplish something in programming. Then you are forced to learn what you need to know. It took me about 3 years on my own and I am still an intermediate. Always new things to learn. eg API. G'luck.