Iterating through a ComboBox's values
Garry,
Thanks for the quick response.
I'm putting together an automated routine that goes something like this:
Sub Macro_Automate()
Dim i As Integer
With Sheets("Settings").ComboBox2
For i = 0 To .ListCount - 1: Debug.Print .List(i):
********* Set "Data_Type" name to the text value equal to the current
ComboBox2 i position *********
Macro_Change_Function
Macro_Export_Output
Next 'i
End With
End Sub
How can I get the named range "Data_Type" to be set before
Macro_Change_Function runs ?
- Ronald K.
|