The Quantitative Quill

Tag: Excel VBA

  • VBA Loops

    VBA loop structures are similar to those of other programming languages. Looping is one of the few things that is extremely difficult to achieve with pure Excel alone. An If… Then statement, for instance, can be written within Excel and comparable results can be achieved. Loops, on the other hand, can be a lot trickier,…

  • Visual Basic for Applications

    One of the coolest Excel features – in addition to the vast repositories of functions that are available in its spreadsheets – is VBA or Visual Basic for Applications. It allows a user to create a procedure – or a macro – to perform more advanced calculations or automate repetitive calculations. Accessing VBA 3. Once…