Passing UserForm Variants into an Array [Excel 14/2010 VBA only)

**lloydgodin** · 12-03-2012, 03:03 PM

I am changing the UI from prompts (code will be in 2nd message) to the below:

Please Login or Register  to view this content.

I was thinking of passing them from the Userform to the module, but think it might be easier to have the userform simply print it into the spreadsheet and then have the main macro (module) read the spreadsheet into an array.

**lloydgodin** · 12-04-2012, 09:38 AM

here is the current code:

Please Login or Register  to view this content.

**lloydgodin** · 12-05-2012, 11:47 AM

Resolved the issue. I passed the information onto the spreadsheet. I then use code to read the data from the spreadsheet into an array where it is then calculated.