Best VBA book for S&T
The best VBA book for first year S&T analyst to read?
The best VBA book for first year S&T analyst to read?
Career Resources
Career Advancement Opportunities
August 2026 Investment Banking
Overall Employee Satisfaction
August 2026 Investment Banking
Professional Growth Opportunities
August 2026 Investment Banking
Total Avg Compensation
August 2026 Investment Banking
“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”
Leaderboard
| 1 | 99.2 | |
| 2 | 99.0 | |
| 3 | 99.0 | |
| 4 | 99.0 | |
| 5 | 98.9 | |
| 6 | 98.9 | |
| 7 | 98.9 | |
| 8 | 98.9 | |
| 9 | 98.9 | |
| 10 | 98.8 |
“... I believe it was the single biggest reason why I ended up with an offer...”
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Programming with VBA by John Walkenbach has helped me.
Thx.
PM me. I have a book for you.
Have PMed you.
I would be interested in hearing suggestions as well!!
Best way for me to learn it was:
Record a macro, go into the code and see how its done
Ya, I totally agree with this.
x3.
For functionality you get stuck with, there's plenty of material easily found via google.
Completely agree as well. You can't learn to code by reading a book (in my opinion)
I think it's most important to come up with some incredibly interesting question that you need to know the answer to and that you can only get that answer by using VBA. Learning programming can be really tough, so you need to have a desire and motivation which outpaces the suck.
Feel free to PM me if you have any questions.
S&T Intern VBA (Originally Posted: 06/08/2010)
I will be starting as an SA in S&T in about two weeks and was just wondering if there are any things in terms of VBA that would be helpful to have covered.
I have been going through Jwalks Power Programming one over the past two weeks and doing all the examples and I am semi comfortable reading code and constructing macros but still need to reference back for specific 'grammar' type things.
I took a look at Option Pricing Models and Volatility by Vainberg and a lot of the stuff was a bit over my head.
Just wondering if there are any tasks that are used often in S&T in terms of VBA that I should have a look at before. If it helps I will be doing rotations on the equities side and prob nothing to quant heavy as I only have an econ and fin background.
Thanks.
I'm interested too
That will likely be more than enough. VBA wasn't my native programming language either (C++) so if I was unsure about syntax I usually just googled it. Furthermore, out of our entire SA class, only myself and one other intern ever did any programming in VBA, from my experience its generally based on how willing you are to lend help in that area.
Sequi quo aspernatur aut quia. Reiciendis ea omnis consectetur aut soluta ea et. Enim maxime nulla sed ea id est est. Libero autem earum odit sit consequatur eos numquam.
Possimus quod voluptatem dolores blanditiis deserunt non. Maxime consequatur aut sit et ut maiores. Reprehenderit nihil molestiae similique.
In mollitia hic ut saepe eaque dolorem fuga. Aut quia dolorem molestias. Et tempora occaecati qui corporis. Nobis dolor voluptate fugit accusantium possimus necessitatibus fugit qui. Quasi est dignissimos cupiditate aut explicabo consequatur sequi est.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...