Consulting

Results 1 to 4 of 4

Thread: how to Enter Values in Multi-Dimensional Arrays using Array() Function?

  1. #1

    how to Enter Values in Multi-Dimensional Arrays using Array() Function?

    Dim sdarray(5) as variant
    Dim mdarray(5,5) as variant

    sdarray = Array("val1","val2","val3")

    How to Pass values in mdarray using Array function?
    We have to use semicolon?

  2. #2
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,296
    Location
    Normally multi dimension arrays are filled using 2 Loops.
    But you can enter them individually like this
    mdarray(1,1) = "A"
    mdarray(1,2) = "B"
    mdarray(1,3) = "C"
    mdarray(1,40 = "D"
    mdarray(1,5) = "E"
    mdarray(2,1) = "F" etc

  3. #3
    Means we can't use Array ( ) function to Enter values in Multi-Dimensional Arrays?

  4. #4
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,296
    Location
    I don't think you can.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •