HOME

 



Other Websites by the Webmaster


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.

  Bookmark and Share


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

 

Chapter 1

Introduction to VBA

Chapter 2

Working with Variables in Excel VBA

Chapter 3

Message Box

Chapter 4

Using If...Then...Else

Chapter 5

For....Next Loop

Chapter 6

Do.......Loop

Chapter 7

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

Chapter 8

Font and Background Color

Chapter 9

Creating a Counter

Chapter 10

String Handling

Chapter 11

Range Selection and Manipulation

Chapter 12

Creating a Quadratic Equation Solver

Chapter 13

Creating a BMI Calculator

Chapter 14

Creating a Financial Calculator

Chapter 15

Creating another Financial Calculator

Chapter 16

Investment Calculation

Chapter 17

Prime Number Tester

Chapter 18

Selective Summation using VBA

Chapter 19

Excel VBA Objects- Part 1

Chapter 20 Excel VBA Objects- Part 2
Chapter 21

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]