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.

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
 


Dear Friend,

Congratulation for completing all the above lessons! Now you can download the E-book version of the Entire Tutorial plus Extra Materials that I have put together specially for you. The Title is "Excel VBA Made Easy". With this e-book , you can learn Excel VBA offline during your leisure hours.

Preview the Book

Download the e-book now

ISBN: 1449959628

Best Regards

Dr.Liew Voon Kiong

p/s: The print version of this book is available at Barnes and Noble

กก

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