EXCELVBA TUTOR is a one-stop Excel VBA tutorial and resource center. We present our tutorial in plain language to help everyone masters Excel VBA effortlessly. Our Excel VBA Sample Programs are also available here. 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.Our tutor, Dr.Liew has also written an e-book, Excel VBA Made Easy. Readers who wish to learn more can download it here. The mobile version is also available on Google’s Play Store. Start learning Excel VBA now by following the lessons below:


1. Introduction to Microsoft Excel VBA 2. Data Types, Constants and Variables
3. Working with Arrays 4.Operators
5. Subroutines and Functions 6. Mathematical Functions
7. Trigonometric Functions 8. Strings Handling Functions
9. Format Functions 10. Financial Functions
11. Date and Time Functions 12. Using If...Then...Else
13. Select Case 14. For...Next Loop
15. Do Loop and While Wend Loop 16.Formatting Font and Background Colour
17. Excel VBA Objects Part 1 18. Excel VBA Objects Part 2
19. The Range Object 20. The worksheet Objecct
21. The Workbook OBject 22. Working with Check Box and Option Button
23. Working with List Box, Combo Box and Toggle Button 24. Creating Charts and Graphs in Excel VBA
25. Creating Animation in Excel VBA

Please visit Excel VBA Sample Codes.


Please visit Excel VBA 2010 Tutorial.

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


About The Tutor

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 books. One of the books, Visual Basic 6 Made Easy was published by createspace.com, an Amazon.com publisher. The rest are ebooks.

  Bookmark and Share

Copyright ® 2008 Dr.Liew Voon Kiong . All rights reserved [Privacy Policy]

Contact: admin@excelvbatutor.com