Library tutorials & articles

Arrays

Reading/Writing to Arrays

You can fill elements of an array very easily. You can use the following syntax:

ArrayName(Element) = Value

Where element is a valid element. The following code declares gArray and fills elements 1,2 and 3 with names.

Dim sArray(1 To 10) As String
sArray(1) = "Paul"
sArray(2) = "Fred"
sArray(3) = "Colin"

Likewise, you can access the value in the array in the same way. The following code displays a message box containing the 3rd value in sArray:

Msgbox sArray(3)

As I said at the start of this tutorial, this can be very beneficial as you can access different values in the array using code. For example, if you hard coded 3 variables:

Dim sName1 As String
Dim sName2 As String
Dim sName3 As String

you would be limited to 3 names, and if you wanted to access them, you would have to write different code for accessing each variable, as you can't type

Msgbox (sName & lNum)

to access sName1, if lNum is 1. With Arrays, you can:

Msgbox sNames(lNum)

Comments

  1. 15 May 2007 at 09:02

    I'm a bit confuse. I would like user to insert how many data they want to put in the array.

    When I declare the array like this

    Dim subjArr( ) As DataType

    How should I write the code so array size is according to user input. This is the code for user to insert how many records should be inserted.

    Dim SubArr() As DataType
    Dim subjNo As String
    subjNo = InputBox("Enter the no of subjects to calculate: ")
    MsgBox (subjNo + " subjects will be calculated")




  2. 20 Dec 2006 at 10:37

    It would work if you used Dim instead of Const. A constant array is not possible in VB and I really don't see the point. Just use a normal array and make sure that it is not modified.

  3. 17 Nov 2003 at 16:35

    Thanks James


    This is a good Array Tutorial for VB Newbies like me.


  4. 29 Apr 2003 at 23:49

    These guys have a perfect working example. The randomizer isn't truly random but completely adequate for basic purposes. I couldn't get it to work as a function, but it worked great when I simply used to function code in-line, so I know it works.


    http://www.4guysfromrolla.com/webtech/110800-1.shtml


    I really just added this in case anyone comes across this in a search as I did


    +++++++++++++++


    check it: FLEETING IMAGE

  5. 03 Apr 2003 at 16:16

    How do I make a constant array? When I try "const data(1 to 72) as byte" it doesn't work, where it would if I used Dim rather than const. Also, isn't there some way to set a value to the whole thing? Like with one command making data(1) = 4, data(2) = 7 etc.

  6. 01 Nov 2002 at 23:17

    No, I believe he means something like this:


    Say you had a string array with 6 elements, beginning with zero.


    The values were arranged like this:


    strArray(0) = "Step 1"
    strArray(1) = "Step 2"
    strArray(2) = "Step 3"
    strArray(3) = "Step 4"
    strArray(4) = "Step 5"
    strArray(5) = "Step 6"


    He wants to randomly arrange the elements' contents, like this:


    strArray(0) = "Step 4"
    strArray(1) = "Step 3"
    strArray(2) = "Step 5"
    strArray(3) = "Step 1"
    strArray(4) = "Step 6"
    strArray(5) = "Step 2"


    I hope this is correct, and/or clear.


  7. 14 Jun 2002 at 15:33

    Are you speaking of randomly pulling one of the values as in say a random name generator?

  8. 30 May 2002 at 08:19

    Can anyone tell me if it's possible to randomly sort the elements in an array?

  9. 20 May 2002 at 19:07

    I'm not familiar to 3d arrays, but could you use something similar to:

    Code:
    Array2 = Split ( Join ( Array1 , "," ) "," )

    I use that to copy 1d arrays.
    Not the best piece of code but meh.

  10. 13 May 2002 at 17:09

    Does anyone know a way of transferring the content of an array into another array WITHOUT doing this?:
    Public Sub  MoveArray()
       For  Z = 0 To  10
           Array2(Z) = Array1(Z)
       Next  Z
    End Sub


    I am dealing with some very large (3 dimensional) arrays and the above kind of operation seems a little slow for the user to sit around waiting for.  (Especially when it will need to be used in the Undo Function)
    Any suggestions will be gratefully received.
    couling@fsnet.co.uk">pcouling@fsnet.co.uk

  11. 01 Jan 1999 at 00:00

    This thread is for discussions of Arrays.

Leave a comment

Sign in or Join us (it's free).