Combobox Array

[Jon_G]

I am trying to populate 8 comboboxes with all the same data from a worksheet in the same workbook in excel

Is it possible to create an array of comboboxes??? Like in VB6?
or do i need to find another way around this problem? I would like to do this

for i = 1 to 8
sheet1.cboItems(i).additem sheet3.range(A1:A12)
next i

but allas i cant seem to make an array of comboboxes in excel
any help?

[RobDog888]

No control arrays in VBA, but maybe you could do a For Each oCtl
on Control or such.