Macros in Microsoft Excel

Consult a software training centre locally. Many of these sort of places offer tutorials on this sort of topic.

The simplest way is to Record a Macro while doing some common tasks like selecting ranges, changing fonts, moving columns, etc. Then, open the macro in VBA and study the methods that were used. For specific questions and usable macros, Google for "Excel VBA Macros". There are many good sites available with free macros. I've written probably close to a hundred macros over the years and own several VBA and macro books, but I've rarely used them since the 'net is much more relevant.

Grae

I fully agree the best way to learn is to record a macro and edit it. But the complications come when you need logical tests to be carried out by the macro. Here, one must learn a few tricks of creating loops and using logical functions. The way out is try and learn. Mahess

Here's a link to a pretty good site with lots of free macros. Study these to get a feel, then tweak them as you wish.

http://www.ozgrid.com/VBA/

Grae

Read the help files.

Get "Excel for Dummies" and "VBA for Dummies"

Play and practice.

That's how I did it.

"VBA for Modelers" by Albright is a text that i used during school. Provides the intro to a modeling concepts and then a elecronic copy of the "answer" model in the attached CD - even the answers are modeled differently, which provides good feedback.

Your typical textbook with concepts and workbook-ish problems but I still refernce it for seldomly used tricks that i forget all too often.

Comment your code!

Good point. Commenting your code can not be stressed enough. Also, try to adopt a consistent method of terminology. What may seem intuitively obvious as you write the code, could very well leave you scratching your head months later.

Grae

I would recommend Mr Excel

http://www.mrexcel.com/

Macrotastic

vba is just a subset of vb, yet vb can be easier to learn, as there is not a need to know a lot about excel. There is a ton of help out there for vb. my fav is www.vb-helper.com, as there is a lot of free downloadable projects and knowledge.

after that, simply recording your own macros, and reading them will be best.

Chris

Hi, Thanks for all the helpful tip and guide you guys given, it did give me some clue how to go about! Moi