Excel VBA Tutorial

Custom Search

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. In this tutorial, we will only focus on developing VBA for Microsoft Excel. Start learning Excel VBA programming by following the lessons listed below.


Table of Contents

Lesson 1: Introduction to Excel VBA Lesson 2: Working with Variables
Lesson 3: Excel VBA Message Box Lesson 4:  Using If ..Then..Else
Lesson 5: Looping Lesson 6: Do….Loop
Lesson 7:Using select Case…End Select Lesson 8: Introduction to Excel VBA Functions
Lesson 9: Formatting Functions Lesson 10: String Manipulating Functions
Lesson 11: Creating User-Defined Functions Lesson 12:Formatting Font and background Colors
Lesson 13:Introduction to Excel VBA Object Part 1 Lesson 14:Introduction to Excel VBA Objects Part 2
Lesson 15: The Range Object Lesson 16: The Worksheet Object
Lesson 17: The Workbook Object Lesson 18: Working with Excel VBA Controls Part 1
Lesson 19: Working with Excel VBA Controls Part 2 Lesson 20: Sub Procedures
Lesson 21: Array in Excel VBA Lesson 22:Creating Animation in Excel VBA
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


Comments are closed.