PDA

View Full Version : Excel VBA dynamic array in a class



dlx
10-21-2010, 05:37 PM
Hi,
Excel 2003
I need to define a 2 dimensional dynamic array in a VBA Class1 and then use the array in another VBA Class2.
Class1 populates the array from a database.

Any help/suggestions would be greatly appreciated.
Is there a reference for using dynamic arrays in VBA classes?

xld
10-22-2010, 01:27 AM
More information required.

Will the class only be accessed from the other class? If so, just instantiate class A from within class B. If it needs to be accessed from elsewhere you need to do something else.