VBA BOOK/EXCERCISES

[mvaysman]

Hi Everyone,
I wanted to find out if anyone can suggest a good book for VBA. Now, I don't need just any book. I want one that offers excercises in a text book like form for VBA as it applies to Excel objects. I have taken VB in college and did very well. I want to sharpen my skills with VBA. A book full of excercises to do in excel would be amazing.
Thank you so much for any suggestions!!

Regards,

MV

 

[doug reich]

There's one or two here: Master reading list for MFE - QuantNetwork - Financial Engineering Forum

 

[Roger Trimble]

I am finding Advanced Modelling in Finance using Excel and VBA to be a useful book. It is on the MFE reading list.

 

[Sanket Patel]

Hi Everyone,
I wanted to find out if anyone can suggest a good book for VBA. Now, I don't need just any book. I want one that offers excercises in a text book like form for VBA as it applies to Excel objects. I have taken VB in college and did very well. I want to sharpen my skills with VBA. A book full of excercises to do in excel would be amazing.
Thank you so much for any suggestions!!

Regards,

MV

If you're inclined, another option would be to simply get a book like Walkenbach along with something like Hull or Carol Alexander's book on pricing financial instruments and code all the models.

You'll learn Excel + VBA + pricing models all in one shot.