Class Module vs. Arrays

[Trip]

Hello all,

I have a quick VBA architectural question and any direction you may be
able to provide would be greatly appreciated.

I have created an Excel application which takes 3 real-time inputs (via
DDE), has roughly 60 variables of different types and about 12 outputs,
and about 2000 lines of code.

I now want to change the application so that it will handle multiple
sets of the 3 inputs simultaneously.

How would you suggest changing the architecture? Move everything into
a class and then instantiate an instance of the related object as
needed? Or, create a large array which can handle multiple instances
of each variable and loop through the array sequentially?

Any thoughts would be great!

Thanks,

Trip

 

[Chip Pearson]

I would go for a class module approach, storing each new instance
of the class in a Collection object.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Trip]

Thank you Chip!

Can you point me to any good examples of this being done? This would
be a great help since I'm somewhat of a class/ood newbie.

Thanks again!

Trip

 

[Dnereb]

set up a class wrapping a variant collection or better thre
collections
as your input class

create a parent class with a variant collection to add inputs in