An Introduction to VBA in Excel
Visual Basic for Applications, Excel’s powerful built-in programming language, permits you to easily incorporate user-written functions into a spreadsheet. 1 You can easily calculate Black-Scholes and binomial option prices, for example. Lest you think VBA is something esoteric which you will never otherwise need to know, VBA is now the core macro language for all Microsoft’s office products, including Word. It has also been incorporated into software from other vendors. You need not write complicated programs using VBA in order for it to be useful to you. At the very least, knowing VBA will make it easier for you to analyze relatively complex problems for yourself.
…
Before we look at examples of VBA, it is useful to have appropriate expectations.
There are several points:
- For many tasks, VBA is simple to use. We will see in a moment that creating simple add-in functions in VBA (for example to compute the Black-Scholes formula) is easy.
- You can do almost anything using VBA. If you can dream of something you would like Excel to do, the odds are that VBA will enable you to do it.
- You will never learn all about VBA by reading a book. If a macro language is so powerful that it enables you to do everything, it is obviously going to be too complex for you to memorize all the commands. A book or tutorial (like this one) will enable you to use VBA to solve specific problems. However, once you want to do more, you will have to become comfortable figuring out VBA by trial and error. The way to do this is…
…
Website: www.math.vu.nl | Filesize: 260kb
No of Page(s): 33
Click here to download An Introduction to VBA in Excel.
Related Tutorial
Tags: basic, macros, microsoft excel, Microsoft Office, VBA
Comments
Leave a Reply