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
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.