By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,806 Members | 1,506 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,806 IT Pros & Developers. It's quick & easy.

to learn vba

P: 1
sir,

i am thinking of learning vba being used in excel to create financial models. i am stuck and have no idea where to start . any suggestions plz.it would be helpful if u give me books name to buy.
Dec 13 '11 #1
Share this Question
Share on Google+
6 Replies


patjones
Expert 100+
P: 931
I would say just go on Amazon or do a Google search. There are a wide array of books out there. Mostly though, you will learn as you go, with assistance from the help pages.

Pat
Dec 13 '11 #2

100+
P: 759
I wish to warn you about starting with Excel VBA.

I also start with Excel VBA but is not (in my opinion) the best start because Access is most powerful.

So, my advice is to start with Access.
Of course, the choice is yours.
Dec 14 '11 #3

NeoPa
Expert Mod 15k+
P: 31,489
I wouldn't agree with that last comment exactly. In some respects that may be wise advice, but not in all situations necessarily. For financial modelling Excel is probably the most interesting. I suspect Mihail is thinking of data manipulation, where Access is the stronger package.

Here are some tutorial links anyway :
  1. Microsoft Access Tutorial.
  2. Microsoft Access Tutorials (Strive4Peace).
  3. Microsoft Office Tutorials.
  4. VBA Tutorial (Excel).

They may not all suit you but I expect you'll find some of them very helpful.
Dec 14 '11 #4

dsatino
100+
P: 393
Also, you need to understand the Object Model of Excel/Access
Dec 16 '11 #5

tuxalot
100+
P: 200
@NeoPa: First link relocated HERE.
Jan 15 '12 #6

NeoPa
Expert Mod 15k+
P: 31,489
Thanks Tux. I've updated my database :-)
Jan 15 '12 #7

Post your reply

Sign in to post your reply or Sign up for a free account.