VBA Excel practice
From C++ to PHP, debugging to webhosting; help and discussion about writing your latest program to running your website. NOT for help when your PC won't work.
| Announcements | Posted on | |
|---|---|---|
-
VBA Excel practice
I've just bought a book on VBA excel for beginners, it's a very good book and goes through many of the basics of VBA programming in excel, but what I really want is some structured problems (with solutions) for VBA Excel, so that I can actually practice writing the code, obviously reading a book that tells you what different commands do is only so good, you need to actually do it. Online tutorials welcome, a quick google and amazon search didn't bring up anything that seemed useful.
Any help much appreciated. -
Re: VBA Excel practiceHey there, I too want to learn VBA skills etc to prep me up for IB, which book did you buy? I bought Excel 2007 Bible and i think its quite good so far.(Original post by Barny)
I've just bought a book on VBA excel for beginners, it's a very good book and goes through many of the basics of VBA programming in excel, but what I really want is some structured problems (with solutions) for VBA Excel, so that I can actually practice writing the code, obviously reading a book that tells you what different commands do is only so good, you need to actually do it. Online tutorials welcome, a quick google and amazon search didn't bring up anything that seemed useful.
Any help much appreciated.
Cheers -
Re: VBA Excel practice
This guy seems to have some tutorials with solutions. He gets more advanced here (MC, BS pricing etc). [Not checked his code for quality.]
There is also a bunch of pre-written code at QuantCode.
Other than that I can only suggest coding stuff out of a mathematical finance book and checking the computed answers against the solutions.