Excecl VBA Classic Excel VBA 2010 Excel VBA 365 Excel VBA Examples About Us

Excel VBA Examples

To complement our Excel VBA tutorials, we have created many interesting examples to help our readers grasp the concepts of Excel VBA programming better. These examples were created using Microsoft Excel 365 but older versions of Microsoft Excel should do just fine. We hope that the examples will offer a captivating learning experience for our learners and help you to improve your programming skill.

For those of you who are using Microsoft Excel intensively in your daily work, we hope that our examples will assist you in developing some useful solutions and ease your workload. For example, you can create Excel VBA macros that can automate the repetitive tasks like payroll calculations , computation of examination grades, statistical calculations and more.

These examples are largely developed using a combination of older versions of Microsoft Excel and the latest Microsoft Excel 365. The syntaxes are basically based on Visual Basic 6. Therefore, if you are already familiar with Visual Basic 6, you should have no problem figure out how to program these examples.

For more examples and detail write up of the examples, please get a copy of our latest book, Excel VBA 365 Made Easy.

Excel VBA Made Easy

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.

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

Contact: Facebook Page