add class into dynamic array

[yaniv20]

Hello friends, need your help please

I have a class, and I need that as soon as the user clicks the button:

1. A new class will be created and entered into a dynamic array.

The array resizes each time the user presses the button.

I just need some example of syntax how to do it.
Thanks in advance

[mikerickson]

You may prefer using a Collection, but in either case, you will need to declare the array as a Public variable in a normal module, so it will not pass out of scope.

Please Login or Register  to view this content.

Note that this is for a 0-based array. And that much of the code is handling to deal with the case of the very first running of Test, where the Array hasn't been dimensioned yet.

Another approach would be to have a fixed size array, larger than you will ever need, and use a companion public variable to indicate what the highest index being used is.

Please Login or Register  to view this content.

This works best with a 1-based array, since when you just start Excel, the value of ArrayElementCount is 0.

The Collection approach is actualy simpler, because the start-up state is easier to detect and that code can be included in the class's Intialize event

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[yaniv20]

Thanks so much, something else I forgot to mention
It is important that its array and values are preserved even after EXCEL closes
Is the solution included?

[alansidman]

Since this has same issue has been opened in the Commercial Services Forum, I am closing this thread. You cannot have more than one thread for the same issue open.