valentines-day-acrostic.pdf File Size: 612.73 KB: File Type: pdf: Created On: 01/12/2009 : Downloads: 12161 Downloads
Following is an example to assign a single element of the array: The above statement assigns element number 5th in the array with a value of 50.0. All arrays have 0 as the index of their first element which is also called base index and last index of an array will be total size of the array minus 1. Following is the pictorial representation of the same array we discussed above:
A VBA array is a type of variable. It is used to store lists of data of the same type. An example would be storing a list of countries or a list of weekly totals. In VBA a normal variable can store only one value at a time. The following example shows a variable being used to store the marks of a student.