How to access element in array

Question

I work in VBA. I converted Javascript Array to VB Array. To be honest it is not 100% vba array...It looks as in attached picture.

I would like to access directly individual items from this array/list. I tried:

Msgbox ConvertedArray(1,1) doesn't work
Msgbox ConvertedArray(1).Item("1") doesn't work

All what is working is counting the size of this "array" by writing

 For each Item in ConvertedArray
 ItemNo = ItemNo+1
 Next

Do you have any clue what is wrong with that array?

Possible duplicate of How to access a element in JavaScript array? — jww
– jww, Commented Aug 29, 2018 at 13:57

CallumDA · Accepted Answer · 2017-02-13 14:42:05Z

0

its the multidimensional array, you will need to access it through index element and not by item string

ConvertedArray(1)(1)

or

ConvertedArray(1).Item(1)

should work for you

edited Feb 13, 2017 at 14:42

CallumDA

12.1k6 gold badges33 silver badges52 bronze badges

answered Feb 13, 2017 at 14:24

Abhinav

1,2001 gold badge8 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jacek Rzadca Over a year ago

Unfortunately it doesn't work. Normal array has diffrent structure. Example: arr(0): -arr(0,0) -arr(0,1) - arr(0,2), arr(1): -arr(1,0), -arr(1,1) etc.

Abhinav Over a year ago

could you provide your code where you have created/Converted ConvertedArray

Collectives™ on Stack Overflow

How to access element in array

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related