PDA

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



prabhafriend
06-20-2010, 10:50 PM
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?

OBP
06-21-2010, 03:48 AM
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

prabhafriend
06-21-2010, 03:54 AM
Means we can't use Array ( ) function to Enter values in Multi-Dimensional Arrays?

OBP
06-21-2010, 06:45 AM
I don't think you can.