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.
http://www.vbtutor.net/VBA/vba_chp21.htm
This is a blog that discusses anything related to Visual Basic and provides updates for VISUAL BASIC TUTORIAL website. Your comments and suggestions are welcome here. Thank you.
Monday, April 19, 2010
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
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
Subscribe to:
Posts (Atom)