Hi,
I currently have a macros which provides a dynamic list of customers to a combo active x control
When user selects the a customer from the dropdown, data updates (formulas) based on that customer.
I have another macro which if run, would create a PDF and email of that data.
I just want to know how to loop for each customer to create the individual pdf's and emails based on the list in the combo box. I.e. as if the user was selecting one then running the macro one by one.
I've seen this on getting the names of customers but not sure how to incorporate it to do what I need?
Many thanks
Melissa
I currently have a macros which provides a dynamic list of customers to a combo active x control
When user selects the a customer from the dropdown, data updates (formulas) based on that customer.
I have another macro which if run, would create a PDF and email of that data.
I just want to know how to loop for each customer to create the individual pdf's and emails based on the list in the combo box. I.e. as if the user was selecting one then running the macro one by one.
I've seen this on getting the names of customers but not sure how to incorporate it to do what I need?
- Sub IterateComboBox()
- Dim i As Long
- With Sheet1.ComboBox1
- For i = 0 To .ListCount - 1
- Debug.Print .List(i)
- Next
- End With
- End Sub
Many thanks
Melissa