Monday, April 19, 2010

New Chapter in Excel VBA Tutorial

We have created yet another chapter for our Excel VBA Tutorial. This chapter shows you how to create arrays in Excel VBA.

When we work with a single item, we only need to use one variable. However, if we have a list of items which are of similar type to deal with, we need to declare an array of variables instead of using a variable for each item. For example, if we need to enter one hundred names, instead of declaring one hundred different variables, we need to declare only one array. By definition, an array is a group of variables with the same data type and name. We differentiate each item in the array by using subscript, the index value of each item, for example name (1), name (2), name (3) .......etc.  

Click on the link below to learn more.

Monday, April 12, 2010

Server Problem- My apology

Dear Vbtutor Users

Our server was not functioning properly due to technical glitch committed by our hosting provider. Most of the links to the lessons cannot be accessed at the moment, please accept our sincere apology. We are confident that the issue will be resolved in a couple of hours, so please be patient and check back again later.

If you still have problem logging to our lessons tomorrow, please leave your message here.
Your feedback is important for us, thank you.

The Vbtutor Support Team