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
Sign in to Reply
  1. Barny's Avatar
    • TSR Legend
    • Location:
    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.
  2. Golden_Gloves's Avatar
    • Junior Member
    • Location: London
    • Posts: 33
    Re: VBA Excel practice
    (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.
    Hey 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.

    Cheers
  3. aaaaz's Avatar
    • Benevolent Member
    • Location: United Kingdom
    • Posts: 737
    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.
  4. Barny's Avatar
    • TSR Legend
    • Location:
    Re: VBA Excel practice
    Hmm, I wasn't really wanting it for Mathematical Finance but those examples are useful none the less, anyone know of anything similar?
Sign in to Reply
Share this discussion:  
Useful resources
Article updates
Moderators

We have a brilliant team of more than 60 volunteers looking after discussions on The Student Room, helping to make it a fun, safe and useful place to hang out.

Reputation gems:
The Reputation gems seen here indicate how well reputed the user is, red gem indicate negative reputation and green indicates a good rep.
Post rating score:
These scores show if a post has been positively or negatively rated by our members.