Looping through ComboBoxes

[dbennett]

I have 104 ComboBoxes in a worksheet named ComboBox1, ComboBox2...

I need to run the following line of code for all of the odd numbered boxes.

Me.ComboBox1.AddItem Worksheets("Picklist").Cells(1, category)
​

I have tried putting the following line in a loop but I keep getting a "Method or data member not found" error.

Me.ComboBox(i).AddItem Worksheets("Picklist").Cells(1, category)
​

Can anyone tell me what I am doing wrong?

Thanks
Diana