TABLE OF CONTENTS
1. Introduction to Microsoft Excel VBA
2. Working with Variables in Excel VBA
3. Message Box
4. Using If...Then...Else
5. For....Next Loop
6. Do.......Loop
7.Select Case........End Select
8. Font and Background Color
9. Creating a Counter
10.String Handling
11. Range Selection and Manipulation
12. Creating a Quadratic Equation Solver
13. Creating a BMI Calculator
14. Creating a Financial Calculator
15. Creating another Financial Calculator
16. Investment Calculation
17. Prime Number Tester
18. Selective Summation using VBA
19. Excel VBA Objects- Part 1
20. Excel VBA Objects- Part 2
21. Array in Excel VBA   
22. Animation in Excel VBA
23. Excel VBA 2010 Tutorial
 

 

VBA is the acronym for Visual Basic for Applications. It is an integration of the Microsoft's event-driven programming language Visual Basic with Microsoft Office applications such as Microsoft Excel.
By running VBA within the Microsoft Office applications, you can build customized solutions and programs to enhance the capabilities of those applications. A lot of people might not realize that they can actually learn the fundamentals of Visual Basic programming without having a copy of Visual Basic professional. Why? Because there is a built-in Visual Basic Editor in Microsoft Excel, and you can use it to customize and extend the capabilities of MS Excel. The applications you build with MS Excel is called Visual Basic for Applications, or simply VBA.

Featured Excel VBA Book

Excel VBA Made Easy

Preview the book


** We have migrated our VBA tutorial site to a more complete tutorial site, please click on Excel VBA Tutorial to visit our new site.

 

About The Tutor

 

Dr.Liew Voon Kiong

The creator and tutor of this online tutorial, Dr.Liew Voon Kiong , holds a Bachelor Degree in Mathematics, a Master Degree in Management and a Doctoral Degree in Business Administration. He obtained the DBA  degree from University of South Australia.

He has been involved in programming for more than 15 years. He created the popular online Visual Basic Tutorial  in 1996 and since then the web site has attracted millions of visitors .It is the top ranked Visual Basic tutorial website in many search engines including Google. He has also written a few Visual Basic related books. One of the books, Visual Basic 6 Made Easy was published by createspace.com, an Amazon.com publisher. The rest are ebooks.


 

Copyright ® 2008 Dr.Liew Voon Kiong . All rights reserved 

Contact: admin@excelvbatutor.com [Privacy Policy]

Home