My company is pulling away from QuickBooks but the ERP we are using has no capability to create quotes, so I'm creating an Excel to manage quotes. To this end, I have a userform to create a quote, with a MultiPage for Job Info, Materials, and Labor.
The Materials page has 21 line items, each with 5 components (a combo box and 4 text boxes per line).
...and so on through Line21.
What I'm trying to figure out is this: Assuming I create an array 'materials(20,4)', is there a way to loop through the lines, line by line, to populate the array or do I need to individually assign each value from the control to the corresponding element of the array? I then want to loop through the array itself to populate the line items on the estimate form.
I have attached the workbook in question if it helps.
I'm still fairly new to VBA as you can probably tell by the code in the userform, so I have some grasp of things but I'm not perfect yet!
Thank you so much for any help you can provide; I really appreciate it! If there's any more information I can provide, please let me know.