MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

guidance on VBA for Excel

  Asked By: Koila    Date: Dec 18    Category: MS Office    Views: 576

I am working as an Accountant and would like to learn VBA for excel
applications. I want to do business modelling etc., using excel and VBA. Could
any body of you please suggest how to learn VBA. As I am working, I can not
spend full time on training.



3 Answers Found

Answer #1    Answered By: Melissa King     Answered On: Dec 18

For me, http://www.mrexcel.com/vbabook.html propelled me from an
Excel Power User (read macro's) into full  fledged VBA. You can't go
wrong with that book if you have already wrestled with macros and do not
already have some programming experience.

As you learn  (by DO-ing), this group can be especially helpful.

Answer #2    Answered By: Clayton Richardson     Answered On: Dec 18

Sounds to me that you should concentrate your efforts on the business,
and buy in a coder to implement your ideas.

Answer #3    Answered By: Adelinda Fischer     Answered On: Dec 18

You could buy "Microsoft Office Excel 2003 Programming Inside Out" by
Curtis Frye. It is a good introductory book especially for doing daily
financial routines.

Introductory financial modelling  can be obtained from "Finanacial
modelling using Excel VBA" by Chandan Sengupta. This book concentrates on
Cash Flow analysis, Derivatives analysis and Bond pricing.

Didn't find what you were looking for? Find more on guidance on VBA for Excel Or get search suggestion and latest updates.