VBA to run multiple macros, combolist and copy/save data

[ramo114]

Hello helpers,

I've attached a scheme of the issue I face. Basically I have a combo box with list of products which I want to run. Each product that is run returns results in cells G10 and G11. I already have two other macros (get data and clear data). Here is how I wanted the operation of the VBA code to go:

1. Run clear data macro
2. Select product A in the combo box
3. Run get data macro
4. Copy value in G10 and G11 to columns E and F of sheet 2 respectively
5. Run clear data macro
6. Select product B and loop the process until the last product

I am sorry I'm unable to share the data. Please assume that the two macros would perfectly well.

Thanks in advance for your help

[ramo114]

Dear colleagues,

I was able to find the loop to go through the combo box but I have trouble copying and saving the results for each loop. Before repeating the loop, I want to copy the values in G10 and G11 for each product and paste to respective rows and columns in sheet2. Please help

Private Sub CommandButton10_Click()
Dim c As Long
With Sheet1.ComboBox1
For c = 0 To .ListCount - 1
.Value = .List(c)

call getdata
call cleardata

Next
End With
End Sub