Excel VBA Tutorial provides plenty of useful lessons written in a straightforward manner to assist you in mastering Excel VBA macro programming. Our lessons cover Excel VBA programming for the older versions of Excel as well as the latest Microsoft Excel 365. However, the syntaxes remain the same because they are based on Visual Basic 6, even for the latest versions of Excel. In addition, we also run tutorials on Visual Basic, JavaScript, JQuery, Blockchain, CSS, and HTML.

Our website is hosted on Linux VPS. However, if you prefer a more robust hosting solution, you can opt for the dedicated server.

Our tutor, Dr.Liew has authored a new e-book, the latest Excel VBA 365 Made Easy. This book can be used as a reference book for your excel VBA projects. Please check it out.

Excel VBA 365 Made Easy

ISBN-13: 979-8642584767

Preview the book

Excel VBA 365 Made Easy is a complete guide to mastering Excel VBA 365, for beginner to intermediate programmers. Authored by Dr. Liew, creator of the popular online Excel VBA Tutorial at excelvbatutor.com, this book is an excellent reference text for high school or college-level computer science courses.

By the end of this book, you will gain a comprehensive understanding of basic Excel VBA 365 concepts and be able to create your own code from scratch. You will learn how to:

  • Write code for objects like Worksheet, Range, Cells and more using their methods and properties
  • Write macros to automate tasks
  • Program code for all the ActiveX controls available in the Developer environment
  • Create applications using the UserForm
  • Create objects and classes using the Class module

Best of all, you will gain inspiration from a variety of interesting examples like a calculator, stock trading program, slot machine, Star Wars, and more. You may modify the examples easily to suit your needs.

Also check out our classic Excel VBA book.

Excel VBA Made Easy

Preview the book

If you wish to learn or brush up Microsoft Excel 365 spreadsheet skills, you can check out our Microsoft Excel 365 Handbook.

What is VBA ?

VBA is the acronym for Visual Basic for Applications.  It is similar to the  Microsoft programming language Visual Basic except that it is embedded within the MS Office applications such as MS Excel, MS Words, MS Access, MS Powerpoint and more.  VBA allows you to create customized programs using the built-in Visual Basic Editor in MS applications.  These programs are also known as macros.  The macros can greatly enhance the functionality of the Microsoft applications.