Home » Forums » Open Source Learning Center » Question and Answer

Whats the best way to learn VBA ?

Submitted by Sandra on 9 January, 2012 - 21:46

hi Excel Experts.
I am an Excel newbie, and I'd like to know whats the best way to learn VBA ?

‹ Multiple files Having Trouble Getting My Userform to Populate the Corresponding Excel Spreadsheet... ›
»
Nick's picture

hi Sandra I think the best

Submitted by Nick on 9 January, 2012 - 21:51.

hi Sandra

I think the best way to learn is to find someone who knows a bit and get them to show you around. That is the absolute best way. Failing that, watch as many videos as you can, and then try to think of a small project that you do each day and want to automate.

Then have a look here: excelexperts.com/Learn-VBA

- there are a few tips to get you started and write your first program.

- recording macros is very powerful, and can get you a long way

 

Once you are progressing, have a look at these tips: VBA -110 tips

Good luck, and if you have any questions, feel free to ask them on the free Excel Experts Members Question and Answer Forum

Nick

 

»

Hi Sandra, The best way to

Submitted by Anonymous on 29 January, 2012 - 16:39.

Hi Sandra,

The best way to learn VBA is recording the macro and then do a self study about how has VBA recorded your steps.

Later you may start genralizing macro so that it could run on any data points i.e. less or more rows that what you have recored it on.

Tushar B

»