Microsoft Excel VBA  means Visual Basic Applications for Excel. Although MS Excel has a lot of built-in formulae and functions, it is still not enough for certain complex calculations and applications. For example, it is very hard to calculate monthly payment for a loan taken using Excel's built-in formula, but it is relatively easy to program a VBA for such calculation. This tutorial is arranged such that you will learn a VBA program a lesson, and there are sixteen such programs at the moment. I will add more lessons in the future.

Introduction Message Box Using If...Then...Else Looping Do.......Loop Select Case........End Case Font and Background Color Counter String Handling Range Selection and Manipulation Quadratic Equation Solver BMI Calculator Financial Calculator Financial Calculator 2 Investment Calculation Prime Number Tester Selective Summation using VBA

[Back to Main Page]

 

---