Pass Array Record
Posted on 2014-03-28
I have a VBA class I created for an Excel project I'm working on.
I have a 2 dimensional array of values that have been read from a worksheet.
For each record in that array, I want to create an instance of the class and then initialize the variables in that class with the values in the array.
What I want to know is ... is there a way in VBA to just pass that array record to the initializing subroutine in the class? Sure, I could just pass them all with array(x,y) notation but I'm wondering if there is a more elegant way. I want to pass just that one record and all it's values (7 currently), not the whole array.