Array Function

Enter your search terms Submit search form




Today I came across one question about Visual Basic arrays, it goes like this:

How would I set an array in visual basic to several things at once? Like:
Dim arrMass(1 To 118) As Integer
arrMass(1) = 1.00794
arrMass(2) = 4.002602
arrMass(3) = 6.941

That gets a bit annoying. Is there a way I can go like:
arrMass() = [1.00794, 4.002602, 6.941]
or something?

The secret to the above answer is to use an array function, where a single variant variable can hold an array. The format is as follows:

                                        Dim myArray as Variant


                                        where x1,x2,x3,......,xn can be either an integer, a single precision number, a double precision number, a string and so on


Let me illustrate this with the example on the right:

Private Sub Command1_Click()
Dim arrMass As Variant, index As Integer

arrMass = Array(1.00794, 4.002602, 6.941)
For index = 0 To 2
Print arrMass(index)

End Sub

The print out will be












 [Back to VBToday]