VBA tutorial

Microsoft 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 you to learn Excel VBA in an easy manner. By following the chapters in this tutorial, you will master Excel VBA in a short time! College and university students who are taking VB related subjects should find this site useful.

Please recommend this website to your friends.
　

EXCEL VBA MADE EASY

Written by the author of this tutorial and published by Amazon.com
This is the print version of Excel VBA Made Easy, click on the picture below to buy the book from Amazon.com

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 most of the basics of Excel VBA through this book. Click on the picture above to download the e-book.

Book Preview

Author: Dr.Liew Voon Kiong

About the Author

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

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