Can I please request for some guidance on template design. I've simplify the below scenario in order to capture the essence of my question.
There exists two workbooks namely, wbStaticData and wbPresentation.
wbStaticData contains historical information.
wbPresentation relies on wbStaticData for data and uses defined functions to do calculations as per business requirements.
wbPresentation has a userform to present the final results.
With wbPresentation_Open event, I open the wbStaticData. Dump the entire data table into an array and store it in wbPresentation userform's array variable.
Any required data for calculation will call upon the userform's array.
By doing it like this, I avoided using globals.
Anyone see anything wrong with this approach? Or should I create a class object to store the data and then hook it on to the userform (I didn't do this because I read somewhere that the userform is just the same as a class object)?
Any feedback is greatly appreciated.