15 Visual Basic for applications

15.1 Why learn VBA?

As you have already seen, Excel is a very powerful tool that can be used to analyse, manipulate and present data in itself. Why then, would one use VBA? Despite all the features found in Excel you may still search for an easier way to solve a task, you may want to create a friendlier user interface, or perhaps you need to add some new capabilities into Excel. VBA gives you the ability to do this.

Many people find it quite intimidating to learn how to program just to use Excel efficiently. And the truth is, it takes some time to learn how to program, but once the effort is made you’ll see a new world of possibilities. In this chapter we’ll teach you just enough to get you going. As you walk ...

Get Financial Modelling and Asset Valuation with Excel now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.