2 Dimensional Array VBA

[Steve001]

Hi,

struggling a bit if someone can help me out please.
I want to create an array with two strings "partno" , "description"
I can create a 1 string array but i haven't got a clue . with two strings

Can you please put comments in the code - still finding my way about with VBA

my string (1) "partnumber", "description"

I want to read the array and come up with the answer bellow

stringa = "partnumber"
stringb =" description"

Hope this makes sense what I am trying to do

Steve

 

[RoryA]

It's not really clear to me why you can't simply add another item to your arrayL

mystring(1) = "partnumber"
myString(2) = "description"

If you need a 2D array, you would use:

mystring(1, 1) = "partnumber"
myString(1, 2) = "description"

 

[Steve001]

Hi Roy,

sorry might not have made my self clear I would like to read down an array table then from an entry be able to get two strings one for a part number another for the description.
or would two arrays be simpler ? one for each ?

Steve

 

[RoryA]

I'd probably just use one delimited string, which you can then parse using Split:

mystring(1) = "partnumber|description"

then you can use:

Stringa = Split(mystring(1), "|")(0)
Stringb = Split(mystring(1), "|")(1)

for example.

 

[Steve001]

Cheers Roy will give that a go

Steve

 

[Steve001]

working thank you

Steve