Excel VBA tutorial

HOME

Other Websites by the Webmaster

VB6 Tutorial

VB2008 Tutorial

Online Business

HTML Tutorial

JavaScript Tutorial

Flash Tutorial

Research Portal

E-book Reading Device

Custom Search

Welcome to Excel VBA Tutorial !

This tutorial is written for anyone who has no previous experience in programming to learn Excel VBA easily! College and university students who are taking VBA related courses should find this site useful.
*Scroll down to start learning Excel VBA.

Please recommend this website to your friends.
　
The print version of Excel VBA Textbook is written by the webmaster and published by Createspace, an Amazon.com Publisher. Click on the book below to buy the book from Createspace eStore.

ISBN: 1449959628

Price: $ 15.00

Excel VBA Made Easy is the Textbook for this tutorial. There are many additional topics in this book not covered in this tutorial. You will learn more about Excel VBA through this book. Click on the picture above to GET the e-book now!

Book Preview

Author: Dr.Liew Voon Kiong

About the Author
VISUAL BASIC 6 MADE EASY
Learning Visual Basic 6 helps you to understand Excel VBA better. This VB6 book is also written by the Author of this tutorial, CLICK on the image below to download the e-book now!

                                          TABLE OF CONTENTS

Introduction to VBA

Working with Variables in Excel VBA

Message Box

Using If...Then...Else

For....Next Loop

Do.......Loop

Select Case........End Select

Font and Background Color

Creating a Counter

String Handling

Range Selection and Manipulation

Creating a Quadratic Equation Solver

Creating a BMI Calculator

Creating a Financial Calculator

Creating another Financial Calculator

Investment Calculation

Prime Number Tester

Selective Summation using VBA

Excel VBA Objects- Part 1

Excel VBA Objects- Part 2

Array in Excel VBA    New!

About The Author

The creator and webmaster 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 related books. One of the books, Visual Basic 6 Made Easy was published by BookSurge LLC, an Amazon.com publisher. The rest are ebooks. Learn more about the author at helium.com
Dear Friends,
If you think you have benefited a lot from our tutorial, please donate generously to us so that we can improve the tutorial further, any amount is welcome. Thanks.
Click on the button below to donate:

Copyright ® 2008 Dr.Liew Voon Kiong . All rights reserved |Contact: admin@vbtutor.net
[Privacy Policy]